Solved

Error: 17836, Severity: 20, State: 17

Posted on 2013-06-11
4
4,128 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
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 9

Expert Comment

by:MattSQL
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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Need Counts 11 43
SQL server 2008 SP4 29 34
Distinct values from two tables 14 18
SQL query to summarize items per month 5 28
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

762 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now