Change the Collation Setting for Clustered SQL Server 2014 Instance

One of our SQL Server 2014 clusters was installed and after the install, my client told me that we are supposed to change the SQL Server collation setting. In this post I will show a procedure to change the collation settings of a clustered SQL Server instance. 

To change the default SQL Server collation you have to rebuild the system databases. Before you rebuild the system databases, review the Microsoft MSDN documentation regarding backup of your system databases and logins.

• https://msdn.microsoft.com/en-in/library/ms190190(v=sql.120).aspx
• https://support.microsoft.com/en-in/kb/918992

When you rebuild the master, model, msdb and tempdb system databases are actually dropped and recreated in their original location.

Change SQL Server Collation Setting for a Clustered SQL Server Instance.

Read My Complete Article "Here" 

Follow and subscribe for more updates: https://mssqllover.blogspot.in/

SQLHyderabad & https://www.facebook.com/MSSQLLover/