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.
 


Total Pageviews