How to Update SQL SERVER 2012 Collation

If you have installed the SQL SERVER 2012 but had setup a different collation, here are the steps to change it:

1. Locate the install folder in the Program files. Usually it is in this folder:

C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012

2.Open the Command Prompt

3. Change Directory to the one above (or where the setup is stored).

4. Run the Script below in the command prompt:

Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLCOLLATION=Latin1_General_CI_AS /SQLSYSADMINACCOUNTS=[username] /SAPWD=[Password]

5. Ensure that the [username] and [Password] are your system administrator account credentials.

6. After running the command, the SQL Server's collation is changed.