Changing the Collation on an SQL Server 2008 R2 Instance

SCCM 2012 RC2 Setup 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

Run SQL Setup using the following parameters to rebuild the Database (You cannot change a collation on the fly):

setup.exe /A CTION=REBUILDDATABASE /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS /INSTANCENAME=M SSQLSERVER /SQLSYSADMINACCOUNTS=%username%

You may need to change the values to suit your SQL Environment

2 responses to Changing the Collation on an SQL Server 2008 R2 Instance

Leave a Reply