Don't Feed the Technician

SQL Server Collation

Yet again i have failed a prerequisite check for the required SQL server collation, though i would post the quick fix for me to remember what i did but might help someone else.

 

Quick back story, i’m installing Microsoft System Centre Configuration Manager 2012, already installed all the prerequisites…

 


Configuration Manager requires that you configure your SQL Server instance and Configuration Manager site database (if already present) to use the SQL_Latin1_General_CP1_CI_AS collation, unless you are using a Chinese operating system and require GB18030 support. For information about changing your SQL Server instance and database collations, see http://go.microsoft.com/fwlink/p/?LinkID=234541. For information about enabling GB18030 support, see http://go.microsoft.com/fwlink/p/?LinkId=234542.

 

The server collation gets specified at the SQL Server installation. Few options to fix, re-install the SQL server or rebuild your database.  The server collation acts as the default collation for all system databases that are installed with the instance of SQL Server, and also any newly created user databases.

Only do this on a SQL which is not in use by any other application!

Assuming you have default instance name, otherwise just change the /INSTANCENAME=

Open up command prompt, navigate to the SQL setup folder where the setup.exe is located and execute the underneath command:

Setup.exe /QUIET /ACTION=REBUILDDATABASE  /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=BUILTIN\Administrators

 

Be patient!

 

Leave a Reply

Your email address will not be published. Required fields are marked *