x

New server with network error

I have a brand new server - Win Server 2008, SQL Standard 2008 and I am getting alerts being fired for Level 20 Alerts. In the log the entry is

Error: 4014, Severity: 20, State: 11.
A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: 109, output error: 0)

This happens randomly, up to 4 or 5 times a day.

Does anyone have any ideas on what might be the cause, and indeed the resolution, please?

I have checked the NIC driver and it's the manufacturers own, not a generic Windows one.

Pings to the server don't drop any packets at all.

Currently the server is under almost no load as I am still benchmarking, configuring ready to go live next month. I am concerned that this problem will get worse if we go live with it.

I have Googled the error and cant see anyone who has actually applied a fix.

[update]
We have updated NIC (Broadcom) drivers and are leaving it 24hours. If it still occurs we will swap to a different port (currently using 1 of 2 on NIC). If it still occurs then we are going to add a PCI NIC from a different manufacturer and see if that has any effect.
more ▼

asked Aug 08, 2011 at 04:03 AM in Default

Fatherjack gravatar image

Fatherjack ♦♦
42.4k 75 78 108

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first
Is it a NIC card or onboard? If a card, maybe try reseating it? (although you'd expect ping drops if that was the case......)
more ▼

answered Aug 08, 2011 at 04:10 AM

Kev Riley gravatar image

Kev Riley ♦♦
52.8k 47 49 76

both are onboard.
Aug 08, 2011 at 04:14 AM Fatherjack ♦♦
some of google results suggest it could actually be caused by the client and not the server?
Aug 08, 2011 at 04:38 AM Kev Riley ♦♦
the only client currently is my version of SSMS
Aug 08, 2011 at 07:04 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left
are the NICs from Broadcom? We've had issues with the misbehaving in the past. Not this exact error, but they were being strange. We swapped to Intel and everything was fine again.
more ▼

answered Aug 08, 2011 at 04:53 AM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

yes, Broadcom. :(

Swapped drivers or NICs?

Was it done under warranty?
Aug 08, 2011 at 05:41 AM Fatherjack ♦♦

we have them as extra NICs and just went to the onboard intel ones. didn't bother with warranty, the machines are in production and have a total of 6 NICs, two broadcom, rest intel. Intel ones are rock-steady.

I/we suspect it is a problem with the broadcom tcp/ip offloading chip not playing nicely with our switches, or something similar.
Aug 08, 2011 at 05:57 AM WilliamD
We have had similar issues with broadcom, updating the firmware of the NIC cards has proven to be successful.
Aug 08, 2011 at 07:07 AM Tim
(comments are locked)
10|1200 characters needed characters left
We were having this issue at one time at previous employers. It was the client application that was using a slightly out of date version of ADO. I'd suggest checking on that first.
more ▼

answered Aug 08, 2011 at 05:06 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
98.7k 19 21 74

no clients are connecting yet, other than my SSMS ... :(
Aug 08, 2011 at 05:40 AM Fatherjack ♦♦
Then never mind. Hmmm... on a guess, @williamD is right and it's hardware, but that's a total SWAG.
Aug 08, 2011 at 05:43 AM Grant Fritchey ♦♦
(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:

x26
x11

asked: Aug 08, 2011 at 04:03 AM

Seen: 3083 times

Last Updated: Aug 08, 2011 at 07:22 AM