6

We have a vendor working on Java (JDBC) application saying they are getting the error

Connection Reset by Peer: Socket Write Error

They are insisting that the SQL Server (SQL Server 2012) is forcibly disconnecting their application server for some reason. I have run Profiler traces to collect Attention and User Error Message events and have found nothing helpful. I have checked the ring buffer and have only failed logins - no disconnects.

SELECT CAST(record AS XML) FROM sys.dm_os_ring_buffers
WHERE ring_buffer_type = 'RING_BUFFER_CONNECTIVITY'

Windows logs do not show anything helpful. Is this an error I should be able to track down in SQL Server, or is this purely a network error that will need a network trace or something else? Any ideas?

Improve this question
2
  • In SQL Server 2012 you should check the system_health session as it has most of the security ring buffer events. As well, a failed login can also be considered a disconnect.
    – user507
    Aug 4, 2015 at 13:11
  • I've seen this happen when I wanted to write a file on a SAMBA drive, and it turned out that the network card was overloaded. When I tried copying large files across the network these failed too, when using COPY and/or Windows Explorer.
    – Henrik Staun Poulsen
    Aug 5, 2015 at 11:18

1 Answer 1

Reset to default
3
+25

Doesn't look like an issue with SQL Server. Here's a link which talks about connection being forcibly closed by sql server :

https://technet.microsoft.com/en-us/library/ms187005(v=sql.105).aspx

Also, the following post might help you analyze the error further :

https://stackoverflow.com/questions/25611741/java-net-socketexception-connection-reset-by-peer-socket-write-error-when-serv

Improve this answer
1
  • Agreed, a socket write error could be the SQL Server OS/Machine having an issue on the network side, but I doubt this would be related to the SQL Server processes unless it was under some extreme conditions.
    – ConstantineK
    Aug 7, 2015 at 23:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.