| SQL Server Message 10054: Possilbe network error: Write to SQL Server Failed. General network error. In the past several years we have had a handful of customers encounter SQL Server Message 10054. This error causes Dynamics SL to disconnect from the SQL Server. The process at the client returns the error 10054. In all cases to date the issue has been hardware related and the resolution has been to disable TOE.TCP/IP Offload (TOE) |
| What is TOE? |
| TOE stands for TCP/IP Offload Engine. TOE moves the processing of data in the TCP protocol stacks from the server CPU to the NIC, freeing CPU cycles for other work. TOE is currently supported for Windows. |
| How does TOE differ from other offload technologies? |
| Offload technologies such as checksum offload, segmentation offload, and Large Send Offload (LSO) deal with specific elements in the driver suite. TOE offloads the TCP protocol stack. |
| Do I have to do anything special to enable TOE? |
| TOE is generally enabled right out of the box; no special configuration is necessary. TOE support requires that “TOE Chimney” for Windows 2003 be installed. |
How to disable TOE
Windows Server 2003 SP2 includes Scalable Networking Pack which enables the TOE (TCP/IP Offload Engine). The problem is that there is a known issue with Broadcom based network adapters. If the network card is not Broadcom based, check to see if it supports this. It is possible that it doesn’t.
To determine if TOE is enabled, you go to HKEY_LOCAL_MACHINESystemCurrentControlSetServicesTcpipParameters then look for the EnableTCPChimney key. If it is set to 1, it is turned on. 0 turns it off.
Once you make this change, the server does require a reboot.
So in short we want to set the HKEY_LOCAL_MACHINESystemCurrentControlSetServicesTcpipParameters EnableTCPChimney flag to 0x0.
http://support.microsoft.com/kb/945977
If you have questions or require additional assistance please contact us at acumaticasupport@swktech.com.
