This project has moved. For the latest updates, please go here.

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

Configure AS Management API

FineBuild can Configure the Management API available for Analysis Services.

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 SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupOLAPAPI FULL Yes Yes Yes Yes Yes
SetupOLAPAPI WORKSTATION Yes Yes Yes Yes Yes
SetupOLAPAPI CLIENT N/A N/A N/A N/A N/A

In order to maintain compatibility with older versions of SQL FineBuild, the parameter ConfigOLAPAPI can also be used.

FineBuild also uses the following parameters to help configure analysis Services Properties:
Parameter Default Description
SetupSQLAS Yes Install SQL Server Analysis Services.

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. Replace \100\ with the value for the SQL Server version you are installing.
SQL 2005 \90\
SQL 2008 \100\
SQL 2008 R2 \100\
SQL 2012 \110\
SQL 2014 \120\

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 - 2014 Edward Vassie. License and Acknowledgements
Previous Configure AS Instance Security Properties Top Configure Integration Services Instance Next

Last edited Dec 22, 2014 at 4:58 PM by EdVassie, version 7