Get error on changing Collation property of Master database of SQL Server

When I change Collation property of Master database in SQL Server 2008, I am getting an error (Please check attached screen-shot for more details).

Does anyone know how can i get rid of this issue?

Regards.
SQLServerMasterDBCollationProper.jpg
LVL 2
GMuradAsked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
To change the collation of master database, you have to use rebuildm utility. You cant do it from SSMS.

But if you need to change the collation of either master or temp database, My kind advice would be to reinstall SQL Server with appropriate collation.

Kindly backup essential things before reinstallation to be on the safer side.
0
 
pcelbaConnect With a Mentor Commented:
Case Sensitive collations are nightmares sometimes...

Create a backup of all your non-system databases, reinstall the SQL Server with proper Collation and restore your backups.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.