November 6, 2013 at 10:10 am
Hi friends,
I'm connecting to sql server 2012 database from management studio 2008R2 from my laptop. I always leave the session open on the management studio, but I've been getting the following error message when I try to query in the same session after a day or so
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
I have never had this problem when I used to connect to any other prior database versions.. Is this some change made in SQL 2012 databases? THanks a lot
November 6, 2013 at 10:26 am
newbieuser (11/6/2013)
Hi friends,I'm connecting to sql server 2012 database from management studio 2008R2 from my laptop. I always leave the session open on the management studio, but I've been getting the following error message when I try to query in the same session after a day or so
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)I have never had this problem when I used to connect to any other prior database versions.. Is this some change made in SQL 2012 databases? THanks a lot
I've seen this exact same message in 2008. I think it happens when SQL Server's network usage is high and it closes some idle connections. I think it is specific to each session you have open as well. After receiving the error in 2008, SSMS seems to be fine afterwards.
November 6, 2013 at 10:28 am
newbieuser (11/6/2013)
Hi friends,I'm connecting to sql server 2012 database from management studio 2008R2 from my laptop. I always leave the session open on the management studio, but I've been getting the following error message when I try to query in the same session after a day or so
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)I have never had this problem when I used to connect to any other prior database versions.. Is this some change made in SQL 2012 databases? THanks a lot
When you get this, try to do the exact same action again and it will work. It disconnects you and then as you try to use it again, reconnects.
Strange
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply