SQL - fatal error occurred

Question

I'm facing an error in the server once a while and I don't know the reason, more details as following:

Log Name:      Application
Source:        MSSQLSERVER
Date:          3/19/2012 8:43:15 AM
Event ID:      4014
Task Category: Server
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      xxxxxxxx
Description:
A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: 109, output error: 0).
Event Xml:
<Event 
xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MSSQLSERVER" />
    <EventID Qualifiers="49152">4014</EventID>
    <Level>2</Level>
    <Task>2</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2012-03-19T12:43:15.000000000Z" 
/>
    <EventRecordID>471395</EventRecordID>
    <Channel>Application</Channel>
    <Computer>xxxxxxxx</Computer>
    <Security />
  </System>
  <EventData>
    <Data>109</Data>
    <Data>0</Data>
<Binary>AE0F0000140000000B0000005600410044004300530051004C0032003000310000000F0000004A00440045005F00500052004F00440055004300540049004F004E000000</Binary>
  </EventData>
</Event>

Thank you

Answer 1

0

The error indicates that SQL has started reading a message from client which potentially spans multiple TDS packets. However in the middle of the message, a network receive operation experienced the problem which usually happens if the connection is reset. That could be caused by the client's termination or by some network issue, e.g. a router resetting the connection. Another factor could be the OS you are using for the server. If it is Windows 2003, then TCP chimney offload could be the problem.

answered Mar 26 '12 at 12:46 PM

robbin
1.6k ● 1 ● 3 ● 5

Thank you Robbin, that's make since, I agree with you. OS is Windows Server 2008 R2 Enterprise. Thanks again.

Mar 26 '12 at 02:32 PM Tony07002

(comments are locked)

SQL - fatal error occurred

Follow this question

Related Questions