Dec
27
2012

Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library [CLIENT: xx.xx.xx.xx]

Error:

 

Error: 17836, Severity: 20, State: 1

Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library [CLIENT: xx.xx.xx.xx]

 

Troubleshooting tips:

  • Perform nslookup of the CLIENT IP Address that is listed in the error message [CLIENT: xx.xx.xx.xx] 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.
  • Get more information 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 xx.xx.xx.xx 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)

 

Solution:

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)

 

Solution reference:

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/04446c40-0623-4528-bbbd-f05f9578e5a0/

http://www.chicagotech.net/netforums/viewtopic.php?f=1&t=15755

 

http://blogs.msdn.com/b/sql_protocols/archive/2006/09/30/sql-server-2005-remote-connectivity-issue-troubleshooting.aspx

Download PDF

About the Author: Nitin G

Indian born, trekker, biker, photographer, lover of monsoons. I've been working full time with SQL Server since year 2005 and blogs to post the content aquired during my research on new topics or fixing issues faced by me as a DBA while working in different kind of projects, hope some of my posts may helps others in SQLDBA community. Everything you read on my blog is my own personal opinion and any code is provided "AS-IS" with no warranties!

Leave a comment

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 2 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

September 2014
M T W T F S S
« Apr    
1234567
891011121314
15161718192021
22232425262728
2930  

View Post by Categories