Configure AS Instance Collation Properties - SQL-FineBuild/Common GitHub Wiki
| Previous Configure AS Instance General Properties | Manual Configuration | Configure AS Instance Security Properties Next |
|---|
FineBuild can configure Instance Collation Properties of the Analysis Services Instance.
The AS Instance Collation Properties should be reviewed to confirm that they have not been changed from the default values shown.
FineBuild Configure AS Instance Collation Properties
The AS Instance Collation 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 |
|---|---|---|
| /ASCollation: | Latin1_General_CI_AS | Character collation set for Analysis Services |
Manual Configure AS Instance Collation Properties
The following steps show what you would have to do for manual AS Instance Collation Properties configuration. FineBuild does all of this work for you automatically.
-
Select the Collation tab
The Collation properties should not be changed from the default values shown
Copyright FineBuild Team © 2013 - 2020. License and Acknowledgements
| Previous Configure AS Instance General Properties | Top | Configure AS Instance Security Properties Next |
|---|