Home Dashboard Directory Help

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



Sign in
to vote
Type: Bug
ID: 782062
Opened: 3/25/2013 11:15:12 AM
Access Restriction: Public
User(s) can reproduce this bug


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 (wajokiel@microsoft.com)
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 (wajokiel@microsoft.com)
Sign in to post a workaround.