An existing connection was forcibly closed by the remote host.

microsoft.public.dotnet.framework.adonet

12 Mar 2007 4:09 PM

salonen

I've seen this message a lot in the groups but I haven't found a
solution for it yet.

Our setup is SQL Server 2000 on a Windows Server 2003 cluster. I
don't believe this issue happened as often when the OS was Server 2000
but that was before I started here.

We see this quite a bit from our wireless clients:
Errors=System.Data.SqlClient.SqlErrorCollection
Class=20 (0x14)
LineNumber=0 (0x0)
Number=10054 (0x2746)
Server=OurSQLServer
State=0 (0x0)
ErrorCode=-2146232060 (0x80131904)
Message=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.)
Data=System.Collections.ListDictionaryInternal

I initially thought it had something to do with them losing the
network connection but when I was trying to recreate (killing the
wireless connection during a long running process) that I always got
the following details:
Errors=System.Data.SqlClient.SqlErrorCollection
Class=20 (0x14)
LineNumber=0 (0x0)
Number=64 (0x40)
Server=OurSQLServer
State=0 (0x0)
ErrorCode=-2146232060 (0x80131904)
Message=A transport-level error has occurred when receiving results
from the server. (provider: TCP Provider, error: 0 - The specified
network name is no longer available.)
Data=System.Collections.ListDictionaryInternal

To recreate the original, all you have to do is run the KILL command
on the spids associated with your application from Query Analyzer.
Given this, I'm focusing on the server itself causing the errors and
not the client computers.

So now we have something to go on when we attempt to code around the
issue. I've been able to "soothe" the issue by executing
SqlConnection.ClearAllPools() when we see a SqlException with a
severity level of 20 or higher. However, I'd like to know if there's
a setup issue with my SQL Server box that I could change that would at
least lessen the frequency of these errors.

Thanks in advance for any advice,
Austin