Configure AS Management API

FineBuild can Configure the Management API available for Analysis Services.

This work is only required for SQL Server 2005 and SQL Server 2008, because the AS Management API is always enabled in more recent versions of SQL Server.

The AS Management API should be enabled as shown below.

FineBuild Configure AS Management API

The AS Management API configuration relates to Process Id 5BFB and is controlled by the parameters below:

Parameter	Build	SQL 2005	SQL 2008	SQL 2008 R2	SQL 2012
ConfigOLAPAPI	FULL	Yes	Yes	Yes	Yes
ConfigOLAPAPI	WORKSTATION	Yes	Yes	Yes	Yes
ConfigOLAPAPI	CLIENT	N/A	N/A	N/A	N/A

FineBuild also uses the following parameters to help configure analysis Services Properties:

Prameter	Default	Description
InstSQLAS	Yes	Install SQL Server Analysis Services. This parameter is set to NO if Express Edition or Workgroup Edition is installed.

Top

Manual Configure AS Management API

The following steps show what you would have to do for manual AS Management API configuration. FineBuild does all of this work for you automatically.

1) Register the Analysis Services management DLL

Open a command window and run the following command:

For a 32-bit server:

"%WINDIR%\Microsoft.Net\Framework\v2.0.50727\regasm.exe" ^
"%PROGRAMFILES%\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.AnalysisServices.dll"

For a 64-bit server:

"%WINDIR%\Microsoft.Net\Framework\v2.0.50727\regasm.exe" ^
"%PROGRAMFILES(X86)%\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.AnalysisServices.dll"