Network problem with server

Question

0.00/5 (No votes)

See more:

Below error is thrown in a already opened program which connects to different database
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.)
Program details: code done using vb.net with MSSQL 2008 as back-end
Two instance of same exe where running simultaneously in same PC but error was thrown only by one instance
Program uses both sqlconnection(ADO.NET) and ADODB connection(upgraded from VB6) and the error is thrown by both types of connection
If the error is due to network problem with the server then why few programs work fine? I am not able to trace the reason for this behavior of the program
Can I know why this error occurs and why only in few programs of same instance

Posted 18-May-12 20:24pm

srikrishnathanthri

Updated 19-May-12 2:21am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2012-05-18T20:52:00

Solution 1

If the problem occurs with the same program only on one client and the other clients work fine the there's something wrong with that specific client. Could be a hardware problem, version problem for SQL Server libraries etc.

Have a look at these:
- http://blogs.msdn.com/b/spike/archive/2009/04/16/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.aspx[^]

- Resolving the error ‘An existing connection was forcibly closed by the remote host’[^]

- Understanding “Connection forcibly closed by remote host” Errors Caused by TOE/Chimney[^]

Posted 18-May-12 20:52pm

Wendelius

Comments

srikrishnathanthri 21-May-12 2:45am

Please provide me with details relating to TOE/Chimney

srikrishnathanthri 22-May-12 7:50am

I executed the below commnad in Command promt in My server which displayed as below
C:\Documents and Settings\Administrator>netsh int tcp show global
WARNING: Could not obtain host information from machine: [PC2]. Some commands may not be available.
The following command was not found: int tcp show global.

Also I looked through the registry, and the TCPChimney related settings seems to be disabled.EnableTCPChimney,EnableTCPA,EnableRSS all have Data set to 0
If SNP related features are disabled then still why I am getting the error?
Server Details: Microsoft Windows Server R2(SP2),Standard x64 Edition

srikrishnathanthri 22-May-12 9:04am

In the client machine under Network Configuration Utility => Advanced Tab I have "TCP/IP offloading" options enable for IPv4 Checksum offload,TCP Checksum offload(IPv4), UPD Checksum offload(IPv4)
Whether the connection error is related to this setting?

Wendelius 22-May-12 14:30pm

You could try changing the value, but as said, if the problem occurs only in one machine, you can compare the settings to a working machine and also check that you don't have hardware related problems (from event log)

srikrishnathanthri 23-May-12 0:41am

May I know which event log you are relating?

Wendelius 23-May-12 0:57am

Check the WIndows Event Log if you have any problems reported by OS

srikrishnathanthri 13-Jun-12 9:56am

Changing the values of the offloads mentioned above didn't solve the problem

Is there any link related TCP KeepAlive and the above mentioned error?
We tried changing the Value of "KeepAlive" to 3600000 by adding new DWORD entry for "KeepAlive" in "HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters" , but still there is transfer of data for every 30 sec(default value)(transfer of data checked using Network monitor)
Also changed the "KeepAlive" value to 360000 in MS SQL configuration manager but no changes in data transfer time
If any problem regaurding TCP Keepalive then how to trace it?