Solved

Error: 17836, Severity: 20, State: 17

Posted on 2013-06-11
4
4,905 Views
Last Modified: 2013-07-03
We are getting the following error in sql server error log

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: 134.47.108.239]
 
Error: 17836, Severity: 20, State: 17

I searched about this on web however i could not find right solution for this
some of the resolution on web:

1.Max socket size change
2.Identify the  remote process responsible for this
3.security settings of remote computer

Could you please let me know the resolution
0
Comment
Question by:chandradineshbabu
[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
4 Comments
 
LVL 10

Expert Comment

by:Sam Simon Nasser
ID: 39240109
one site specifies:
Again, I suggest you run network monitor to see who/what is hitting your server on the specified port. Perhaps, this is some internal inventory software that is scanning the network.  Changing tcp port does not solve the problem here.
also
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 xxx.xxx.xxx.xxx 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).
0
 

Author Comment

by:chandradineshbabu
ID: 39240123
I have already gone through above solution which are already  present on the web and mentioned in the my question itself.

Request you please mention any alternatives for this issue.
0
 
LVL 10

Expert Comment

by:Matt Bowler
ID: 39240467
So if you've been through these troubleshooting steps - did you identify the originating process?
0
 
LVL 23

Accepted Solution

by:
nemws1 earned 500 total points
ID: 39241627
Is this client:  134.47.108.239  on your network?

If so, did you identify the employee on this machine?  Did you ask them what they were doing at the time the error occurred?  What program were they connecting to the database with?
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.

630 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