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

Previous Configure AS Instance Collation Properties Manual Configuration Configure AS Management API Next

Configure AS Instance Security Properties

FineBuild can configure Instance Security Properties of the Analysis Services Instance.

The AS Instance Security Properties should be set as shown below.

Security Compliance

AS Instance Security Properties configuration helps to focus SSAS administration rights on to the DBA Team. If you setup Security Compliance then AS Instance Security Properties configuration will always be implemented.

FineBuild Configure AS Instance Security Properties

The AS Instance Security Properties configuration relates to Process Id 5BFA and is controlled by the parameters below:

Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014 SQL2016
SetupOLAP FULL Yes Yes Yes Yes Yes Yes
SetupOLAP WORKSTATION Yes Yes Yes Yes Yes Yes
SetupOLAP CLIENT N/A N/A N/A N/A N/A N/A

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

FineBuild also uses the following parameters to help configure Analysis Services Security Properties:
Parameter Default Description
GroupDBA nothing Name of the DBA System Administration Windows group

Top

Manual Configure AS Instance Security Properties

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

1) Select the Security tab
Click Add to add windows groups to the Analysis Services Server Administrators role. These groups will have administrator rights within Analysis Services.
Security.png
2) Use the process Find Group on Domain with the GroupDBA value to configure Analysis Services Administrator.

3) Click OK to save any changes made.
Save.png
Copyright FineBuild Team © 2013 - 2015. License and Acknowledgements
Previous Configure AS Instance Collation Properties Top Configure AS Management API Next

Last edited Jul 8, 2015 at 10:49 AM by EdVassie, version 6