Installation Instructions

Download the proper binary from the latest release of ASSP

Start by opening SQL Server Management Studio (SSMS)
  • If you want the Assembly available to all databases, right clicking on the Assemblies node under the Server.
  • If you only want the Assembly available to a single database, right click on the Assemblies node under that database.

Then choose the "new Assembly..." option

01_NewAssemblyMenu.png

When the register assembly dialog box comes up, use the browse button to locate the ASSP.DLL file.

02_RegisterAssembly.png

The other important choices to make are what name to give to the assembly reference and what security permissions to allocate. Keeping the default name of "ASSP" will mean that all of the example scripts should work without modification. Note that there are some functions that will only work if the assembly is registered with unrestricted permissions.

03_AssemblyDetails.png

For ASSP2012, you must unblock the DLLs before registering them because .NET 4.0 added this restriction. If you don't unblock the DLL, then you will get the "Clr Assembly must have main file specified." error. Right click on the file and choose Properties and unblock:

unblock.png

Also, make sure you are using the SQL Server Management Studio version which corresponds to your Analysis Services version. For example, if you're using Analysis Services 2012, make sure to use SSMS 2012 to create the assembly. If you use SSMS2008 to create an assembly on a AS2012 server, you may receive the "Clr Assembly must have main file specified." error.

Last edited Feb 13, 2013 at 2:18 AM by furmangg, version 8