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

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

FineBuild Configure AS Instance General Properties

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

Top

Manual Configure AS Instance General Properties

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.

  1. Using SQL Server Management Studio, start the Analysis Services instance if it is stopped

    Connect to it for Object Explorer

    ![SSMS Explorer](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/SQLConfiguration/InstanceConfiguration/ConfigureAnalysisServicesInstance/ConfigureASInstanceGeneralProperties/SSMS Explorer.png)

  2. Right-click and select Properties

    ![SSMS Properties](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/SQLConfiguration/InstanceConfiguration/ConfigureAnalysisServicesInstance/ConfigureASInstanceGeneralProperties/SSMS Properties.png)

  3. 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

    Directories

  4. Scroll and set the following value. For a Full build, the local Administrators access must be removed.

    Item Value
    Security \ BuiltinAdminsAreServerAdmins False

    ![Alt=Builtin Admins](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/SQLConfiguration/InstanceConfiguration/ConfigureAnalysisServicesInstance/ConfigureASInstanceGeneralProperties/BuiltIn Admins.png)

  5. Scroll to see the Port number and set the following value:

    Port

Copyright FineBuild Team © 2013 - 2020. License and Acknowledgements

Previous Configure Analysis Services Instance Top Configure AS Instance Collation Properties Next