Previous Configure AS Instance Properties Manual Configuration Configure Integration Services Instance Next

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"

RegisterAPI.png
Copyright © 2013 Edward Vassie. License and Acknowledgements
Previous Configure AS Instance Properties Top Configure Integration Services Instance Next

Last edited Feb 14, 2013 at 12:47 PM by EdVassie, version 2

Comments

No comments yet.