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

Previous Configure Analysis Services Instance Manual Configuration Configure AS Instance Collation Properties Next

Configure AS Instance General Properties

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 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 Properties:
Parameter Default Description
SetupSQLAS Yes Install SQL Server Analysis Services
DrvBackupAS Drive letter for database backup files. See /Drv... Parameters
DrvDataAS Drive letter for database data files. See /Drv... Parameters
DrvLogAS Drive letter for database log files. See /Drv... Parameters
DrvTempAS Drive letter for database log files. See /Drv... Parameters
DirSQL SQLFiles High-level folder name for SQL Server files
TCPPortAS 2083 TCP Port for Analysis Services

The DrvBackupAS, DrvDataAS, DrvLogAS, DrvTempAS and DirSQL parameters are used during the SQL Server install process to define the folders used for database files, as shown below:
Model Example
DrvBackupAS:\DirSQL\MSAS.MSSQLSERVER.Backup I:\SQLFiles\MSAS.MSSQLSERVER.Backup
DrvDataAS:\DirSQL\MSAS.MSSQLSERVER.Data J:\SQLFiles\MSAS.MSSQLSERVER.Data
DrvLogAS:\DirSQL\MSAS.MSSQLSERVER.Log K:\SQLFiles\MSAS.MSSQLSERVER.Log
DrvTempAS:\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, then connect to it for Object Explorer.
SSMS Explorer.png
2) Right-click and select Properties.
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| J:\SQLFiles\MSAS.MSSQLSERVER.Data
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.png
3) Scroll and set the following value. For a Full build, the local Administrators access must be removed.
Security \ BuiltinAdminsAreServerAdmins False

BuiltIn Admins.png
4) Scroll to see the Port number and set the following value:
Cannot resolve image macro, invalid image name or id.
Copyright FineBuild Team © 2013 - 2015. License and Acknowledgements
Previous Configure Analysis Services Instance Top Configure AS Instance Collation Properties Next

Last edited Jul 8, 2015 at 11:47 AM by EdVassie, version 8