[SOLVED] Microsoft SQL Server 2012 Management Studio Crash when opening a new query window

At times, when opening a new query window, or selecting top 1000 rows, Microsoft SQL Server 2012 Management Studio would crash with the following error message “SQL Server Management Studio has stopped working“:

SQL Server Management Studio has stopped working

SQL Server Management Studio has stopped working

When I click on the “View problem details” link, we can get a few unhelpful details about “CLR20r3“, “ssms.exe“, “Microsoft.VisualStudio.Platform.VSEditor” and “System.NullReferenceException“, thank you very much.

After much googling with Bing, all solutions pointed to restarting the machine. Well, I wanted to avoid that, as my server is in production.

I thought, well, let’s be smart and delete a few folders in my %AppData% directory. It can’t get worse and might solve the issue.

It did get worse. I couldn’t even start Management Studio anymore, and a friendly error message “The directory name is invalid” mentioning “mscorlib” as the source of the problem.

I deleted the whole local profile, it solved the “mscorlib” issue. But my original “CLR20r3” was still there.

And then my eyes wandered in the bottom right corner of the screen, and noticed a weird asterisk (starlike symbol) in the language preferences tray:

Language Preferences Dialog

Language Preferences Dialog

Mmm, let’s switch that to “ENG“. Start SQL Server Management Studio again and … tada! It works! Problem solved!

Wonderful. No idea where this asterisk comes from, and why the editor crashes because of that.

I hope this will help someone out there.

This entry was posted in SQL Server, Tip, Windows and tagged , , , , , , , . Bookmark the permalink.

24 Responses to [SOLVED] Microsoft SQL Server 2012 Management Studio Crash when opening a new query window

  1. Martín Mora says:

    Thank you very much, that worked for me 🙂

  2. Thank you very much! It works!

  3. Luis Rivera says:

    That works very well, follow the same path you did, until I read this wasn’t sure on how to fix that.

  4. Thank you so much That was the solution to my problem also.
    great article. at first i thought is was a joke. but it did really work.


  5. Nizamul says:

    For me (as a new user ) its helpful if put all the steps with details. Because Start >run> %AppData% (Administrator > Appdata>Roaming ) Here I found many folder .If I delete all what problem can happen…….because my server also in production .

  6. Rodrigo says:

    it’s works 😀 Thanks

  7. Interesting. Doesn’t seem to be my case. First off my language preferences don’t appear on the tray. And when I do check in control panel I find it does read “English United States” no *

  8. This problem went away in my case after we applied all WINDOWS patches. I am not sure which exact patch killed it though.

  9. Ricardo Tapia says:

    Lamentablemente hice todo lo que indican. La única solución fue reinstalar el “Management Studio”. En mi caso fue una la versión 2014 de SQL que presento el mismo problema.

  10. John Edward says:

    Muchas Gracias!! fue de mucha ayuda tu recomendación para soluciónar el inconveniente.

  11. Brian says:

    Nice that works for me, thanks.

  12. Diego Rios says:

    Excelente amigo, como llegaste a esa conclusión, si nos puedes compartir esa solución.


  13. Wintoro Jati says:

    thank you, it’s work

  14. Amol Jadhav says:

    it’s works😀 Thanks

  15. ayoub lamrini says:

    Thank you very much! It works!

  16. Harry says:

    This is awesome ! … Fixed my issue.
    Unbelievable !

  17. Fernando says:

    Love you

  18. Duco says:

    works for SQL 2016 as well

  19. Alam says:

    Thanks You Very Much

  20. Daniel says:

    I was getting crazy with this, thank you so much. Obviously work for me, I have “??” for language.

  21. John J Serna says:

    You really help me and save me a lot of time, thanks!!

  22. Majid says:

    Thank you very much it works for me too

  23. Andres Agredo says:

    It works, thanks!

  24. Nanang says:

    Lol…but it works 🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s