Solved

SQL Server 2005 17836, Severity: 20, State: 1

Posted on 2008-06-09
2
10,039 Views
Last Modified: 2011-10-27
We are getting this annoying repeated errors in the errorlog

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: x.x.x.x]

We dont have log shipping or any jobs that constantly ping the SQl Server port.

Questions is
a. Is it a serious error or just informative?
b. If it is just informative error is there anyway we can avoid getting this error?
c. Is there anyway we can configure SQL Server so that it wont write this error to error log?

We are on SQL 2005 SP2
0
Comment
Question by:MAK999
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 14

Accepted Solution

by:
Daniel Junges earned 500 total points
ID: 21745857
This is SQL Server 2005 reporting that you sent some invalid bytes to it in a request.  SQL Server 2000 did not have this level of error reporting.

about this error see:
http://gps678.com/21/bdd422f86d719067.html
0
 

Expert Comment

by:Sufleu
ID: 22258398
This error will also appear when someone tries to telnet to your sql server for testing or probing.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question