How to change SQL 2012 database collation SQL_Latin1_General_CP1_CI_AS, the requirement for System Centre Configuration Manager (SCCM) 2012.
Changing database collation means all data in the database will be lost – make sure you know what you are doing.
I needed to change the database collation for my SCCM instance in relation to an SCCM installation error:
“Configuration Manager requires that you 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 operating system and require GB18030 support.”
To change the database collation simply run the setup.exe from the SQL Installation media again but in quite mode. The command you need to run is:
setup /q /action=rebuilddatabase /instancename=sccm /sapwd=Pa$$w0rd /SQLCollation=SQL_Latin1_General_CP1_CI_AS /SQLSYSADMINACCOUNTS=domainadministrator
more info: www.hermanarnedo.com