Thursday, June 20, 2013

Required SQL Server collation SCCM 2012 failed

When SCCM 2012 setup runs the prerequisite check, sometime it will fail if SQL server collation is not configured. If SQL Server 2008 installed with the default values without specifying custom value then that is the problem.
The error MSG shows as below:


Complete error MSG is “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.”

 Solution:
The server collation is specified during SQL Server 2008 installation.  To address this particular issue, you may need to re-install the SQL server.

To change the existing SQL server collation, follow this link:
http://technet.microsoft.com/en-us/library/ms179254(v=SQL.100).aspx

We should specify SQL Server Collation when installing the SQL Server itself. The value should be SQL_Latin1_General_CP1_CI_AS

Where to set SQL Server Collation:
During the SQL Server installation, on the following step we can specify a custom collation.