Configure AS Instance Security Properties - SQL-FineBuild/Common GitHub Wiki

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.

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:

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

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.

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

Previous Configure AS Instance Collation Properties	Top	Configure AS Management API Next