Error message when an application connects to SQL Server on a server that is running Windows Server 2003: "General Network error

最新推荐文章于 2024-10-30 22:31:58 发布

envykok

最新推荐文章于 2024-10-30 22:31:58 发布

阅读量228

点赞数

分类专栏： SQL Connection + Issue Resolution 文章标签： server sql server network application windows microsoft

SQL Connection + Issue Resolution 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

http://support.microsoft.com/?kbid=942861

Problem:

Consider the following scenario. A server is running Windows Server 2003 and Microsoft SQL Server. You have an application that connects to SQL Server by using TCP/IP. In this scenario, you may intermittently receive one of the following error messages when the application connects to SQL Server:

Error message 1

[Microsoft][ODBC SQL Server Driver][DBNETLIB] General Network error. Check your network documentation

Error message 2

ERROR [08S01] [Microsoft][SQL Native Client]Communication link failure

Error message 3

System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

You may also receive one of these error messages when the network load on SQL Server is high. For example, you may receive one of these error messages when you replicate databases in SQL Server. Or, you may receive one of these error messages when a multiple-user application accesses databases in SQL Server.

Reason

This problem occurs because the TCP Chimney Offload feature is enabled on the server. The TCP Chimney Offload feature is enabled by the Windows Server 2003 Scalable Networking Pack.

Typically, this problem occurs when the network adapter uses the Broadcom 5708 chipset. For example, the following network adapters use the Broadcom 5708 chipset: