Connection to SQL Server 2005 fails randomly
Posted on 2011-02-24
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.
That didn’t solve the problem.
We are open to any suggestions at this point.