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
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:
    <Provider Name="MSSQLSERVER" />
    <EventID Qualifiers="49152">4014</EventID>
    <TimeCreated SystemTime="2012-03-19T12:43:15.000000000Z" 
    <Security />
Thank you
more ▼

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

Tony07002 gravatar image

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 voted first
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

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



Answers and Comments

SQL Server Central

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



asked: Mar 22, 2012 at 07:29 PM

Seen: 2869 times

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