Changing SQL Server System Collation without reinstalling

Changing SQL Server collation after the install isn't fun but here are two examples of how to do that without reinstalling SQL Server again.

Both of these examples will work on SQL Server 2014 to 2019 I haven't tested on earlier versions as those are out of support.

Follow us on

[ReponHaque]

The second option worked perfectly for me. Thanks very much.

[vhanka]

The second option worked perfectly. Thank you ever so much!

[TKDti]

Thank you very much, you saved my life. You don't know how much I thank you, your video is the best.

[jinan.es.]

Thank you very much, man! worked perfectly.

[dorinstefaneanu]

Tried both methods, but collation doesn't change after server restart, it remains to Latin1_General_CI_AS . What could be the cause of that, thanks

[ilyeshmusic]

with second method i changed the system DB's but not the server collation. Any hint maybe ? The cmd commands got through but i've got connction errors in etween index restore...i never came to the ctr+c command at the end of cmd script....

[BalwinderSingh-cnir]

I too have user databases in development environment, but the collation of them is different from the system databases.

If I use the 2nd method to change the collation will there be any corruption? I understood that it will change collation for system and user db and that is fine for me.

Please assist

[lmntrik]

I discovered your 1st method does not work if you remove SAPWD from the syntax. Nothing would happen and there would be no update/produce for summary.txt in Logs. To make this work I had to include an SAPWD with the rest of the line.

[MasterNacho]

Thank you very much, friend!!, this is perfect!!

[sachinmohite]

Thank you so much....It works for me....

[ImanolMayoRojas]

Thank you very much, this video really helped me a lot!

[barnalinandy]

I have Rebuild the database with second method you just mentioned in the video. however I don't see the NT Service Account login anymore how do we restore it ?

[xz]

Hello, thanks for the video. Q does this work for 2 clustered win2016 SQL 2019? same procedure?

[wildone]

good video! BTW any chance you know how to change collation of single database? Simple alter statement doesn't work as I get dependency errors...

[Hewbuntu]

Thanks for the vid:) I've heard stories that changing the collation without using the setup can cause corruption. Have you heard about this? Has it ever happened to you? thx

[lxkhati]

it works... great thanks... and subscribed.

[andresf]

Thank you so much bro! You saved my job haha... best regards!

[rouspookichatpatikitchen]

Thanks it helps me alot...but use AD account with password...as it don't work with location NT service account.