question

Fatherjack avatar image
Fatherjack asked

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.
networkalerts
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
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......)
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
both are onboard.
0 Likes 0 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
some of google results suggest it could actually be caused by the client and not the server?
0 Likes 0 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
the only client currently is my version of SSMS
0 Likes 0 ·
WilliamD avatar image
WilliamD answered
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.
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
yes, Broadcom. :( Swapped drivers or NICs? Was it done under warranty?
0 Likes 0 ·
WilliamD avatar image WilliamD commented ·
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.
0 Likes 0 ·
Tim avatar image Tim commented ·
We have had similar issues with broadcom, updating the firmware of the NIC cards has proven to be successful.
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
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.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
no clients are connecting yet, other than my SSMS ... :(
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Then never mind. Hmmm... on a guess, @williamD is right and it's hardware, but that's a total SWAG.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.