a
Previous Configure AS Instance General Properties Manual Configuration Configure AS Instance Security Properties Next

Configure AS Instance Collation Properties

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 5BFA and is controlled by the parameters below:

Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupOLAP FULL Yes Yes Yes Yes Yes
SetupOLAP WORKSTATION Yes Yes Yes Yes Yes
SetupOLAP CLIENT 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
ASCollation Latin1_General_CI_AS Character collation set for Analysis Services

Top

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.

1) Select the Collation tab.
The Collation properties should not be changed from the default values shown.
Collation.png
Copyright © 2013 - 2014 Edward Vassie. License and Acknowledgements
Previous Configure AS Instance General Properties Top Configure AS Instance Security Properties Next

Last edited Dec 22, 2014 at 3:56 PM by EdVassie, version 5