Saturday, February 22, 2014

The collation of the site database does not match the collation of the parent site's database

I had SQL error at the Prerequisite Check page regarding the required SQL Server Collation:

"The collation of the site database does not match the collation of the parent site's database.  All sites in a hierarchy must use the same database collation.in SCCM 2012"


Configuration Manager required that you configure your SQL Server instance and Configuration Manager Site database (if already present) to use the SQL_Latin1_General_CP1_CI_AScollation,





The server collation is specified during SQL Server installation.  So this means that you need to 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.
It is highly recommend to do this only on a SQL which is not in use by any other application!
Navigate to your SQL setup folder or DVD 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


No comments:

Post a Comment