SQL Server Performance

Error 4014

Discussion in 'SQL Server 2005 General DBA Questions' started by satya.sqldba, Jul 10, 2007.

  1. satya.sqldba New Member

    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
  2. dineshasanka Moderator

    http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx 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
    http://dineshasanka.spaces.live.com/
  3. satya.sqldba New Member

    Error state is already in the message in my post right?

    Am I missing something?

    Thanks
    Satya
  4. satya Moderator

    No doubt its a network issue, usehttp://support.microsoft.com/kb/812953/ to get netmon trace.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    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.
  5. satya.sqldba New Member

    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
    Satya

Share This Page