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