SSMS 2012 crashes when some of the servers are no longer available (i.e. "transport not available") - by Cornan The Iowan

Status : 


Sign in
to vote
ID 782062 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 3/25/2013 11:15:12 AM
Access Restriction Public


I use multiple database queries ("New query" from a Registered Server group) every working day.

Sometimes, one of the servers may have gone offline or been rebooted.

If I then try to execute a multiple server Transact-SQL script against the servers / instances, SSMS will crash and "recover" (losing some tabs in the process).

Because the program crashes I don't yet have a screenshot.  I'll try to get one and upload it later.
Sign in to post a comment.
Posted by Microsoft on 6/17/2013 at 12:12 PM
Hello, Conan. This has been fixed in (2012) SP1. If updating your installation does not fix the issue, please post here again and we will reactivate the item. Otherwise, this will be resolved as fixed.

-Walter A Jokiel, Program Manager, SQL Server (
Posted by SAinCA on 5/31/2013 at 12:51 PM
I was connected to instances on Network1.

Disable the NICs to get onto a VPN that's only accessible via wireless.

Connected to Network2.Instance and started to wite a query.

"Management Studio has stopped working" with "Searching for a solution".

It restarted OK, but it really shouldn't have cared about the temporarily unavailable instances so much as to CRASH and lose any work in progress on another instance!
Posted by Microsoft on 5/28/2013 at 9:45 AM
Hello Conan. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you. -Walter A Jokiel, Program Manager, SQL Server (