Thursday, April 04, 2013

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.

image

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)




image



Note your

“INSTANCENAME=MSSQLSERVER” and/or


“SQLSYSADMINACCOUNTS=Domain\Administrator” may be different…

Post a Comment

Blog Archive