Cannot reconnect at the Query level by Jake Cunningham FS

Closed

as Duplicate Help for as Duplicate

Type:	Bug
ID:	777695
Opened:	1/28/2013 11:10:38 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

In SQL 2012, I am not able to reconnect a query when the connection is lost. To reproduce, run a query and then break the connection (either leave the network or let it set for a while). When you try to run it again, you get "TCP Provider error - an existing connection was forcibly closed by the remote host." That is fine and expected, excpet I cannot reconnect (Query -> Change Connection -> Connect is greyed out and disabled).

Details (expand)

English

SQL Server 2012 - Developer Edition

Tools (SSMS, Agent, Profiler, Migration, etc.)

Windows 7 Enterprise (SP1)

US English

1.) Connect and run a query
2.) force a disconnection by leaving the network or keeping the window open and inactive for a while.
3.) Run the query again. You should receive "TCP Provider error - an existing connection was forcibly closed by the remote host."
4.) In the top menu, try to click Query -> Change Connection -> Connect. It is disabled.
5.) Only way to run the query again is to open a new query window.

Connect button and Query -> Change Connection -> Connect menu item are disabled.

The Connect button should be enabled so I can simply reconnect and run the query.

X64

File Name	Submitted By	Submitted On	File Size
ConnectionLost_ExpectedMessage.png	Jake Cunningham FS	1/28/2013	19 KB
ConnectButtonDisabled.png	Jake Cunningham FS	1/28/2013	21 KB

Posted by Microsoft on 2/5/2013 at 5:16 PM

Hello, thanks for writing in to Microsoft.

We are closing this connect item as a duplicate of this one: https://connectadmin/Feedback/ConnectTab.aspx?FeedbackID=762563

Regards,
Sanjay Nagamangalam, SQL Server Manageability

Microsoft