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

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?

  • 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
    Commented 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. Commented Aug 5, 2015 at 11:18

1 Answer 1


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


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


  • 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. Commented Aug 7, 2015 at 23:01

Your Answer

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

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