Change collation in SQL Server 2012

I run into the issue that the collation of my existing MS SQL 2012 Server wasn’t according to the pre-requisites of the SCCM 2012 SP1 Installation. So I had to Change the collation on the SQL Server to SQL_Latin1_General_CP1_CI_AS, this is the syntax:

/SQLSYSADMINACCOUNTS=accounts [/SAPWD= StrongPassword ] [ /SQLCOLLATION=CollationName]

In my example, I executed the following:



Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.