Error 4014 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error 4014

Hello Everyone, Today I had an error 4014 happpening. The error message says: Error: 4014, Severity: 20, State: 2. Message
A fatal error occurred while reading the input stream from the network. The session will be terminated. I know that this is some sort of network problem, but not sure how important it is to give a serious thought. I just wanted to know what (probably) might have caused this error. Thanks
Satya says You can turn on sql trace to see which client operation caused this failure? Also, from error log, you should be able to see the error state, can you provide it?
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at

Error state is already in the message in my post right? Am I missing something? Thanks
No doubt its a network issue, use to get netmon trace. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Ok That was helpful, from the event viewer log, the error appears to have occured from a particular login, I think finding out what job was run at that time also might help. Thanks