Configure AS Instance General Properties
| Previous Configure Analysis Services Instance | Manual Configuration | Configure AS Instance Collation Properties Next |
|---|
SQL FineBuild can configure Instance General Properties of the Analysis Services Instance
The AS Instance General Properties should be set as shown below
The AS Instance General Properties configuration relates to Process Id 5BFB 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 Properties:
| Parameter | Default | Description |
|---|---|---|
| /SetupSQLAS: | Yes | Install SQL Server Analysis Services |
| /VolBackupAS: | Drive letter for database backup files. See /Vol... Parameters | |
| /VolDataAS: | Drive letter for database data files. See /Vol... Parameters | |
| /VolLogAS: | Drive letter for database log files. See /Vol... Parameters | |
| /VolTempAS: | Drive letter for database log files. See /Vol... Parameters | |
| /DirSQL: | SQLFiles | High-level folder name for SQL Server files |
| /TCPPortAS: | 2083 | TCP Port for Analysis Services |
The /VolBackupAS:, /VolDataAS:, /VolLogAS: and /VolTempAS: parameters are used during the SQL Server install process to define the folders used for database files, as shown below:
| Model | Example |
|---|---|
| /VolBackupAS:_DirSQL_\MSAS.MSSQLSERVER.Backup | I:\SQLFiles\MSAS.MSSQLSERVER.Backup |
| /VolDataAS:_DirSQL_\MSAS.MSSQLSERVER.Data | J:\SQLFiles\MSAS.MSSQLSERVER.Data |
| /VolLogAS:_DirSQL_\MSAS.MSSQLSERVER.Log | K:\SQLFiles\MSAS.MSSQLSERVER.Log |
| /VolTempAS:_DirSQL_\MSAS.MSSQLSERVER.Log | T:\SQLFiles\MSAS.MSSQLSERVER.Temp |
The following steps show what you would have to do for manual AS Instance General Properties configuration. FineBuild does all of this work for you automatically.
-
Using SQL Server Management Studio, start the Analysis Services instance if it is stopped
Connect to it for Object Explorer
-
Right-click and select Properties
-
Select the General tab
Ensure Show Advanced/All Properties is checked, then set the following parameter values
Create the BackupDir, DataDir, LogDir and TempDir folders if they do not already exist. If any of the folder names are set incorrectly then Analysis Services will not start after it has been stopped
Property Value AllowedBrowsingFolders I:\SQLFiles\MSAS.MSSQLSERVER.Backup\AdHocBackup BackupDir I:\SQLFiles\MSAS.MSSQLSERVER.Backup\AdHocBackup DataDir J:\SQLFiles\MSAS.MSSQLSERVER.Data LogDir K:\SQLFiles\MSAS.MSSQLSERVER.Log TempDir T:\SQLFiles\MSAS.MSSQLSERVER.Temp 
-
Scroll and set the following value. For a Full build, the local Administrators access must be removed.
Item Value Security \ BuiltinAdminsAreServerAdmins False 
-
Scroll to see the Port number and set the following value:
Copyright FineBuild Team © 2013 - 2020. License and Acknowledgements
| Previous Configure Analysis Services Instance | Top | Configure AS Instance Collation Properties Next |
|---|