Yes i know its not exactly Azure but you know sql works on Azure VM and other ways we need ssms or management studio having said that i was testing sql migration and when i installed ssms 18.1 version i was unable to open it that's the today's issue.
So essence of the story : unable to open management studio 18.1 version even after restart system , uninstall install and tried all the basic troubleshooting and finally i come across the solution , no not my solution but provided by the MS because its a known issue. "Sad i wasted couple of hours "
3) Remove the line that has the following text (should be line 38):
NgenBind_OptimizeNonGac enabled=“1”
So essence of the story : unable to open management studio 18.1 version even after restart system , uninstall install and tried all the basic troubleshooting and finally i come across the solution , no not my solution but provided by the MS because its a known issue. "Sad i wasted couple of hours "
The recommended workaround is you need to follow below steps :
1) Close all instances of SSMS
2) Edit ssms.exe.config (location below)
1) Close all instances of SSMS
2) Edit ssms.exe.config (location below)
C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE
3) Remove the line that has the following text (should be line 38):
NgenBind_OptimizeNonGac enabled=“1”
After that save the file and restarted my computer and it worked but still unable to open from RUN but yes from management studio on desktop.
No comments:
Post a Comment