SSMS SQL SERVER Management Studio 2012 startup freeze

3firelegs picture 3firelegs · Aug 19, 2014 · Viewed 20.7k times · Source

I have a strange situation. IT installed SSMS on my laptop and it runs well the first time, connected to my SQL servers remotely etc. But then it's frozen. I forced quit and then started SSMS again. Now it's totally frozen, no popup window at all to enter the server-connection text string. Then I did a force quit and got a pop up window (see it here ).

Microsoft SQL Server Management Studio has detected that an operation is blocking user input. This can be caused by an active modal dialog or a task that needs to block user interaction. Would you like to shut down anyway?

Has anyone seen this before? My IT department has no clue.

Answer

MemeDeveloper picture MemeDeveloper · Jul 21, 2015

Often this is due to the new connection dialog being off screen (usually due to changing monitor setup e.g. 1 to 2 monitors or resolution change etc).

If so the really easy fix (if your connection dialog just needed approval without changing fields) is :

  1. Focus on SSMS and Hit Enter/Return

..or the easy fix (if above does not work - as your last connection is not ready to go) is:

  1. Alt Tab to SSMS
  2. Alt + Space - context menu
  3. M - select Move (in offscreen context menu)
  4. Arrow Key(s) - to move it back onto screen

As per answers here from @Eirik Toft and here from @Lee Chetwynd