sql-server-2008 - 如何解决错误 17836，严重性 : 20, 状态 : 14?

Question

网络数据包负载中指定的长度与读取的字节数不匹配；连接已关闭。请联系客户端库的供应商。错误:17836，严重性:20，状态:14。我几乎同时收到此错误 5 次，想知道其发生的原因。

Answer 1

查看解决方案here :

Since the SQL Server has Event ID 17836 logged, the SQL port is open. It is more like authentication issue. Based on this articles (Configuration for querying SQL database remotely – http://www.howtonetworking.com/others/testsqlconnect2.htm ), we may have 3 fixes:

• creating SQL login ID (recommended)
• join the computer to the domain
• allow anonymous connections to SQL Server 2000 or to SQL Server 2005 (don’t recommend)

还有这个MSDN forum

Perform a nslookup of the CLIENT IP Address that is listed in the error message and find out what computer it is that is connecting. Then you need to check that machine and determine what specifically is connecting to the SQL Server. You might get more infromation from doing a SQL Trace for the Errors and Warnings Event Class and have the ClientProcessID column in the trace data. When the error spikes, you might get the PID for the process that is connecting from that 10.26.32.96 machine, and then you can find that process in Task Manager on that machine by adding the PID to the data displayed (View -> Select Columns).