Configure AS Instance Security Properties
| Previous Configure AS Instance Collation Properties | Manual Configuration | Configure AS Management API Next |
|---|
FineBuild can configure Instance Security Properties of the Analysis Services Instance.
The AS Instance Security Properties should be set as shown below.
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.
The AS Instance Security Properties configuration relates to Process Id 5BFA and is controlled by the parameters below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupOLAP: | Yes | Yes | N/A |
| SQL2017 | /SetupOLAP: | Yes | Yes | N/A |
| SQL2016 | /SetupOLAP: | Yes | Yes | N/A |
| SQL2014 | /SetupOLAP: | Yes | Yes | N/A |
| SQL2012 | /SetupOLAP: | Yes | Yes | N/A |
| SQL2008R2 | /SetupOLAP: | Yes | Yes | N/A |
| SQL2008 | /SetupOLAP: | Yes | Yes | N/A |
| SQL2005 | /SetupOLAP: | Yes | Yes | 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 |
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.
-
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
-
Use the process Find Group on Domain with the GroupDBA value to configure Analysis Services Administrator.
-
Click OK to save any changes made
Copyright FineBuild Team © 2013 - 2020. License and Acknowledgements
| Previous Configure AS Instance Collation Properties | Top | Configure AS Management API Next |
|---|