SCCM 2012 SP1, SQL 2012 on Server 2012

If like me you ‘skimmed’ the pre-reqs for SCCM 2012 SP1 and then cant install due to the database collation (see below), here is how to fix it.

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

Setup.exe /QUIET 
/ACTION=REBUILDDATABASE  
/SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS 
/INSTANCENAME=MSSQLSERVER 
/SQLSYSADMINACCOUNTS=Domain\Administrator

(all above is one line)

Note your

“INSTANCENAME=MSSQLSERVER” and/or


“SQLSYSADMINACCOUNTS=Domain\Administrator” may be different…