To be more specific, Native error 10054 is Winsock error "Connection Reset by Peer", ConnectionRead (recv()) means that the TCP connection was terminated on server when the client was reading data from the socket.
1. Was server restarted when there are exisiting connection to it. 2. Check SQL error log to see there was any exception thrown around the time when the client received the error, an exception in sql results in the corresponding connection being dropped. 3. If this happened intermittently, sometime the error could indicate network hardware issue. You should involve your network admin to trouble shoot using netmon etc. This posting is provided "AS IS" with no warranties, and confers no rights.
To be more specific, Native error 10054 is Winsock error "Connection Reset by Peer", ConnectionRead (recv()) means that the TCP connection was terminated on server when the client was reading data from the socket.
1. Was server restarted when there are exisiting connection to it. 2. Check SQL error log to see there was any exception thrown around the time when the client received the error, an exception in sql results in the corresponding connection being dropped. 3. If this happened intermittently, sometime the error could indicate network hardware issue. You should involve your network admin to trouble shoot using netmon etc. This posting is provided "AS IS" with no warranties, and confers no rights.
