Winsby Group LLC Corporate Logo

SQL Server Connection Failure

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

Cause

This issue occurs because Windows Server 2003 and later versions implement a security feature that reduces the size of the queue for concurrent TCP/IP connections to the server. This feature helps prevent denial of service attacks. Under heavy load conditions, the TCP/IP protocol may incorrectly identify a valid TCP/IP connections as a denial of service attack.

Resolution

To resolve this issue, turn off this new functionality by adding the SynAttackProtect entry to the following registry key on the computer that is running Microsoft SQL Server that houses your BizTalk Server databases.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters

Set the SynAttackProtect entry to a DWORD value of 00000000. To do this, follow these steps:

  1. Click Start, click Run, type regedit, and then click OK.

  2. Locate and then click the following registry key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters

  1. On the Edit menu, point to New, and then click DWORD Value.

  2. Type SynAttackProtect, and then press ENTER.

  3. On the Edit menu, click Modify.

  4. In the Value data box, type 00000000. Click OK.

  5. Quit Registry Editor.

Note To complete this registry change, you must restart the computer that is running SQL Server.

Revised: 2011-03-30
Next