How to Resolve the error when checking Prerequisites in SCCM 2012 Setup “Required SQL Server Collation”

When you installing SCCM 2012 and when it comes to Prerequisites checking part and in case if you face a error like “SQL Server Collation Failed”, then there is a way to sort it out.

 

image

Configuration Manager requires you to 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 operation system and require GB18030 support. When you doing the SQL installation there is a place where you can configure the collation part.

 

image

 

But in case if you could not make it and if you get a ERROR AS “SQL Server Collation Failed”, then below is the solution to correct it.

Note: However always make sure this change will not effect other applications if you are using a SQL server as a shared one. Simply it is recommended to do the changes if the SQL is purely only for ConfigMgr.

So resolve steps as below;

Step –1

Navigate to SQL server image and run the below command.

Below sada is my dmain Name and SCCMADMIN is my SCCM Service account. In case if you have added other admins accounts in to SQLSYSADMINACCOUNTS then put those as well. Basically after the each admin accounts put them as follows .

 

setup.exe /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=”sada\sccmadmin” /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

 

For additional information, you can refer to the below link

http://technet.microsoft.com/en-us/library/ms179254%28v=SQL.100%29.aspx

 

Hope the above guidance will help you.

 

Cheers 🙂

Advertisements

One thought on “How to Resolve the error when checking Prerequisites in SCCM 2012 Setup “Required SQL Server Collation”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s