Views:

Important This article contains information about how to change the registry. Make sure that you back up the registry before you change it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and change the registry, click the following article number to view the article in the Microsoft Knowledge Base:

322756 How to back up and restore the registry in Windows

You receive the following error message on various screens in Microsoft Dynamics SL:

SQL Server Message 10054

Possible network error: Write to SQL Server failed. General Network Error. Check your documentation

Symptoms
Cause 1
The TCP/IP offload engine (TOE) is turned on in Windows Server 2003. The TOE may have been turned on when you installed Windows Server 2003 Service Pack 2. To resolve this problem, see Resolution 1.

Cause 2
A network adapter is malfunctioning on the server or on a workstation. To resolve this problem, see Resolution 2.

Cause 3
Other hardware in the network is malfunctioning. This may include a router, a switch, or other hardware. To resolve this problem, see Resolution 3.

Cause
Warning Serious problems might occur if you change the registry incorrectly by using Registry Editor or by using another method. These problems might require you to reinstall the operating system. Microsoft cannot guarantee that these problems can be resolved. Change the registry at your own risk.

Resolution 1
To disable the TOE, follow these steps:

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

Expand HKEY_LOCAL_MACHINE, expand SYSTEM, expand CurrentControlSet, expand Services, expand Tcpip, and then click Parameters.

Right-click EnableTCPChimney, and then click Modify.

In the Value Data box, type 0, and then click OK.

Exit Registry Editor.

Restart the server.

Resolution 2
If users receive the error message on all the workstations, replace the network adapter on the server that is running Microsoft SQL Server. If users receive the error message only on a single workstation, replace the network adapter on that workstation.

Resolution 3
Replace the hardware that is malfunctioning.

Resolution
For more information about this error message, click the following article number to view the article in the Microsoft Knowledge Base:


942861

Error message when an application connects to SQL Server on a server that is running Windows Server 2003: "General Network error," "Communication link failure," or "A transport-level error"
 

Keywords: SQL, 10054