SQL management studio hangs when opening after being closed down on dual screen

Solution 1:

I have found the answer on the server fault site:

https://serverfault.com/a/491235/171795

Unfortunately I can't vote the guy up (https://serverfault.com/users/166318/eirik-toft) as I don't have any reputation on that site (or this site that my question got migrated too) However, I thought I would leave this answer here as a signpost to his answer.

To work around the issue I 'alt-tab' to select the main sql window. Then 'alt-space' to get the context menu then 'm' to select move, then I used the arrow keys to brings the hidden dialogue box into view.

Solution 2:

It might be a bit late for this but I suffered from the same problem. Happens to me when I close it on the second monitor with it attached at the corner. The simple solution to me was to just hitting escape with the focus being on the Manager. That closes the dialog so you can control the manager again. Then move it to the main monitor and try to connect. A lot simpler then trying to move the dialog into focus.

Solution 3:

Thanks for the answers here guys!

It helped me to find a permanent solution when using a dual screen setup.

After you've managed to get the Object Explorer back on the screen you can close it and configure Management Studio (2014) to not open it automatically during startup. This will prevent the phenomenon from occurring when Management Studio is set to open on your secondary screen automatically.

Do so by going to Tools > Options > Environment > Startup

For the option "At startup:" select "Open empty environment", click "OK" and you're rid of this annoyance. :-)