2uzhan.com
Advertisement
Now Place:2uzhan.com » Connection failures

Connection failures

Microsoft SQL Server @ October 16, 2008   Views:0

Hi

We have been having a lot of trouble with connection failures in some of our database apps. I've turned on trace flags 4029 and 3689 on our SQL box, this was recommended to help try and track down the problem. After setting these on we've been seeing entries like these below in the SQL error log and application event logs.

2008-10-17 16:22:09.30 spid261 Error: 17824, Severity: 20, State: 1
2008-10-17 16:22:09.30 spid261 Could not write to Net-Library 'SSNETLIB', loginname '', hostname 'A Client'. Connection closed..
2008-10-17 16:22:09.30 spid261 Error: 17059, Severity: 18, State: 0
2008-10-17 16:22:09.30 spid261 Operating system error 10054: An existing connection was forcibly closed by the remote host...

And also...

2008-10-16 14:33:01.53 spid276 Error: 17824, Severity: 20, State: 1
2008-10-16 14:33:01.53 spid276 Could not write to Net-Library 'SSNETLIB', loginname '', hostname 'The SQl box'. Connection closed..
2008-10-16 14:33:01.53 spid276 Error: 17059, Severity: 18, State: 0
2008-10-16 14:33:01.53 spid276 Operating system error 4: The system cannot open the file...

We also have Wireshark capturing the traffic on port 1433 but this isn't really telling us anything useful.

I should point out here that the SQL box is virtual but is dedicated. It is SP4 and also fully patched barr the very latest MS updates.

Does anyone have any ideas what could be wrong here. This is a huge problem for us and we are beginning to lose favour with our users the longer this goes on.

I appreciate any help you can give here, and if you need any more info I'll tell you what I can.

--------------Solutions-------------

Dave - excellent first post - I wish they all were so detailed.

I don't know the answer - I'm responding to let others know this is posted elsewhere. This might have a simple resolution, it might not. If the latter it us useful for everyone to know all the facts:
http://www.sqlservercentral.com/Foru...87908-9-1.aspx

Have you googled this and accounted for the suggestions others have had to the same error?

Tags:
© 2018 2uzhan.com Contact