Windows Server - Intermittent Connection Errors

Asked By MikeReaga on 16-Oct-07 12:11 PM
I am not sure if this is the correct newsgroup to post in. Recently (last 2
months or so) we started seeing errors in our web apps on our production web
server. At first glance, they seem SQL Server like SQL Server connection
errors with ASP.NET 2.0.

Example of error:
A transport-level error has occurred when receiving results from the server.
(provider: TCP Provider, error: 0 - An established connection was aborted by
the software in your host machine.)

A reboot seemed to fix the problem, but only for a while. Then the problem
became more frequent. I thought it was .NET specific. But then I noticed some
ASP 3 apps were having problems too, and was getting "General network error"
when connecting to the database.

And then I thought it must be a problem with IIS. But then, a console app
that runs on the server that is built with VB6 was returning connection
errors on sending emails through SMTP and now .NET applications are
expeiriencing SocketExceptions as well when trying to send emails.

I have to point out that the problem does not come up every single time you
load a page or run a program on the server. It is very frequently
intermittant.

All of these apps are running on other developement servers just fine, and I
even stress tested them to see if that was the problem, but no matter what,
the problem does not appear to effect the other servers.

This is a standard Windows Server 2003 with SP2 and is current on all
updates. I am wondering if there is some problem with the network stack on
the server not working correctly since it seems to be affecting nearly every
program that connects to another service on another box.

Does anyone have any ideas or advice about where to go from here.

Thanks in advance.




Mathieu CHATEAU replied on 16-Oct-07 03:20 PM
Hello,

did you install the SQL client on the web server ? If so, you must exactly
have the same sql service pack as the SQL Server.

W2K3 SP2 makes big changes on the network stack.

You may experience network-related problems after you install Windows Server
2003 SP2 or the Scalable Networking Pack
http://support.microsoft.com/kb/936594
=>can you apply the fix of this KB ?

--
Cordialement,
Mathieu CHATEAU
English blog: http://lordoftheping.blogspot.com
French blog: http://www.lotp.fr