debugsqlMinor
Connection Reset by Peer: Socket Write Error
Viewed 0 times
errorpeerwritesocketresetconnection
Problem
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.
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?
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?
Solution
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
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
Context
StackExchange Database Administrators Q#108485, answer score: 3
Revisions (0)
No revisions yet.