You're always welcome to interrupt me when I make a mistake :hehe. provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. Example 8-6 The netstat -s Command Displays TCP / IP Statistics C : > netstat - S IP Statistics Packets Received 1091043 Received Header Errors 0 Received.
Yes, it is also a trasport layer error because the connection with the server has got disconnected but it is somewhat different.Ĭan you look on this link, without knowing much about the N/W configuration i will not be able to comment much because it does not seems to me an sql server specific issue because as you said it got randomly disconnected so pls check the below link out. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Ī transport-level error has occurred when sending the request to the server. MSDP Error Codes and Subcodes Error Code Error Error Subcode O - Bit Description Subcode Description State Message header error 0 Unspecific Bad message. I always respect your words but the Error msg we recieve for the above situation is somewhat different.
You'll get the same error if the server is restarted or if someone killed your SPID.
