December 18, 2012

Microsoft SQL Server Management Studio 2012 (ssms.exe) Hangs, Not Responsive, Freezes after connecting to, servers

Problem:

Ok so today, I had strange encounter with the (Ssms.exe) Microsoft SQL Server Management Studio 2012.
After connecting to a server and then clicking on anything in the Object Explorer treeview, the program simply stopped working, it froze up, got the "Not responding" flag and I was only able to quit the the program from the task manager. By now I though that it was some kind of upgrade from Microsoft, because this morning there was alot of updates. But no, it was not the upgrade, or to tell you the truth, i don't really know if it was.
But i narrowed it down to some faulty files in my profile belonging to SSMS. after deleting them the whole thing worked again, and I was able to continue my work.

Solution 1: will reset the SSMS totaly
Solution 2: will reset the SSMS but keep your connection settings

Solution 1:

  1. Close the SSMS
  2. Delete this folder:
    %userprofile%\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0
  3. Start the SSMS again

Solution 2:

  1. Close the SSMS
  2. Backup this file:
    %userprofile%\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\SqlStudio.bin
  3. Delete this folder:
    %userprofile%\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0
  4. Start the SSMS and close it again, without connecting to any server.
  5. Restore the file:
    %userprofile%\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\SqlStudio.bin
  6. Start the SSMS again.
 


1 comment:

  1. Thank you for this post. I know its a little old, but it still helped me. But, I was wondering if this resolved your issue for the long term. This solution resolves my issue, but it comes back every few days. I even uninstalled and reinstalled SQL 2012. Same problems

    ReplyDelete

Total Pageviews