Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 729
  • Last Modified:

SQL Server: An existing connection was forcibly closed by the remote host

I am getting the following error when using our product that connects to SQL. It is pretty random and I have diffuculty reproducing it.

The error is:
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 noticed that it is a generic TCP error and that people have replaced switch etc with no resolution. I have also tried the SynAttackProtect registry key also which did not resolve the issue.
Machines are all Windows 2003 SP2 and its Microsoft SQL Server Standard Edition (9.00.1399.06)
0
GlennCameron
Asked:
GlennCameron
  • 6
  • 5
1 Solution
 
YveauCommented:
... MS would say: first patch the machine and than try again. Latest service pack (SP2) and recommended hotfix would give you 9.00.3054.00 ...

Next to that, it might have something to do with the number of concurrent connections. Is that set to a maximum or 0 ? To check: right click on the server in the object explorer pane of SSMS, choose properties. Then select the connections page and see for the 'Maximum number of concurrent connections' ... should say 0 meaning unlimited. That is if you have that kind of license ...

Hope this helps ...

0
 
GlennCameronAuthor Commented:
OK, got SP2 installed and I am still recieving errors. My build number is now 9.0.3042. I can not find any other updates to bring the build number up to 3054
0
 
YveauCommented:
You need hotfix KB934458 to get to 9.0.3054:
http://support.microsoft.com/kb/934458/

Hope this helps ...
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
GlennCameronAuthor Commented:
Thanks for that, I am now running 9.0.3054, however the error continues to happen.
0
 
YveauCommented:
From any specific machine or just any ?
Also from the server itself ?

Any messages in the eventviewer on hardware level ?
0
 
GlennCameronAuthor Commented:
Nope no errors in the logs on either the SQL server or the application machine.
0
 
YveauCommented:
Errors from all connecting machines ?
I once had something like this (lost connections) due to a bad network cable ... :-\
0
 
GlennCameronAuthor Commented:
I am getting it on more the one SQL server and client with it now which points more at my Cisco Catalyst 2924-XL switches. Can you help me diagnose issues with the switches?
0
 
YveauCommented:
Sorry, I'm only a simple database guy ... switches are not my area of expertise ...
0
 
GlennCameronAuthor Commented:
Thanks for you reply. I think  found my last issue. The port groupings were missing off the ports I had my crossovers cable on.
0
 
YveauCommented:
Glad I could be of any help and thanks for the grade !
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now