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

avatar 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

avatar image

1.7k 1 5 10

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.

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: 3883 times

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

Copyright 2018 Redgate Software. Privacy Policy