Solved

Connection to SQL Server 2005 fails randomly

Posted on 2011-02-24
5
762 Views
Last Modified: 2012-05-11
We have a clientside program, residing on a user’s local machine that runs multiple read-only queries against an MS SQL Server 2005 database running on an internet server running Windows Server 2008.  The connection fails at random delivering up this error message.

[DBNETLIB][ConnectionWrite(send()).]General network error.  Check your network documentation.

We tried mounting the database on a secondary server running Windows Server 2003 and SQL Server 2000 and the problem disappeared.  

Feeling the problem related to the server configuration, we disabled the chimney, thus:

netsh int  tcp set global chimney=disabled

When that failed to fix the problem, we turned off the SynAttackProtect feature by altering the setting in the Windows registry.  

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\SynAttackProtect=00000000

That didn’t solve the problem.

We are open to any suggestions at this point.

Thank you,

Eric Wilson
0
Comment
Question by:cerebrumconsulting
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 5

Expert Comment

by:robertg34
ID: 34973776
make sure you have gone through this procedure of opening the ports on the windows 2008 server.  SQL ports are closed by default:
http://support.microsoft.com/kb/968872

0
 

Author Comment

by:cerebrumconsulting
ID: 34974428
We have opened port 1433 and we do get a connection often. The failure is random.  It just pops up after we have already run queries successfully.  Are there other ports that we need to open? Would closed ports cause a random or occasional error like this?

Thanks,

Eric
0
 
LVL 13

Accepted Solution

by:
upalakshitha earned 500 total points
ID: 34976116
try this
1. Click Start, click Run, type regedit, and then click OK.
2. Locate and then click the following registry subkey:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters

3. In the right pane, make sure that the DisableTaskOffload registry
entry exists. If this entry does not exist, follow these steps to add the entry:

a. On the Edit menu, point to New, and then click DWORD Value.
b. Type DisableTaskOffload, and then press ENTER.

4. Click DisableTaskOffload.
5. On the Edit menu, click Modify.
6. Type 1 in the Value data box, and then press ENTER.
7. Exit Registry Editor.

[note]DisableTaskOffload is by default set to 0 on 2003 Systems and on 2008 Server it is set to 0xff = 255 which is neither 0 nor 1 , basically, vista or 2k8 systems TCP/IP stack does not configure this setting, hence stopping all applications which depend on this flag to ignore it.
0
 

Assisted Solution

by:cerebrumconsulting
cerebrumconsulting earned 0 total points
ID: 34978720
Thanks.  We'll try this today.  Since it's a randomly occuring situation, it will require a period of testing before we can be sure that the problem has been fixed.

 
0
 

Author Closing Comment

by:cerebrumconsulting
ID: 35067679
Thanks.  We haven't had a recurrence of the error since applying this solution, so it seems this was the solution we'd been looking for.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question