"SQL Server Message 10054" error in Microsoft Dynamics SL

  • Article

This article provides a solution to error messages that occur on various screens in Microsoft Dynamics SL.

Applies to:   Microsoft Dynamics SL
Original KB number:   945130

Introduction

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, see How to back up and restore the registry in Windows.

Symptoms

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

Cause

This problem occurs for one or more of the following reasons.

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.

Resolution

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 can't guarantee that these problems can be resolved. Change the registry at your own risk.

Resolution 1

To disable the TOE, follow these steps:

  1. Select Start, select Run, type regedit, and then select OK.
  2. Expand HKEY_LOCAL_MACHINE, expand SYSTEM, expand CurrentControlSet, expand Services, expand Tcpip, and then select Parameters.
  3. Right-click EnableTCPChimney, and then select Modify.
  4. In the Value Data box, type 0, and then select OK.
  5. Exit Registry Editor.
  6. 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.

More Information

For more information about this error message, see Solving Connectivity errors to SQL Server.