Solved

Connection to SQL Server 2005 fails randomly

Posted on 2011-02-24
5
742 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
  • 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

760 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now