x

SQL - fatal error occurred

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
more ▼

asked Mar 22, 2012 at 07:29 PM in Default

Tony07002 gravatar image

Tony07002
0 1 1 2

Does this occur during a BLOB related operation?
Mar 23, 2012 at 01:02 PM eghetto
(comments are locked)
10|1200 characters needed characters left

1 answer: sort oldest
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.
more ▼

answered Mar 26, 2012 at 12:46 PM

robbin gravatar image

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, 2012 at 02:32 PM Tony07002
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x579

asked: Mar 22, 2012 at 07:29 PM

Seen: 2708 times

Last Updated: Mar 26, 2012 at 04:57 PM