Solved

Connection to SQL Server 2005 fails randomly

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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Redirected folders in a windows domain can be quite useful for a number of reasons, one of them being that with redirected application data, you can give users more seamless experience when logging into different workstations.  For example, if a use…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
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…

751 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