Frequent IIS restart required with web service / ado.net

Hello All,

I'm looking for additional troubleshooting ideas on a persistant problem
that is cropping up 'randomly' when a web service is communicating with the
SQL server.

Both machines are running win2k Server with the most recent service packs +
..NET 1.1. The Web Service provides data to client software by connecting to
the SQL server and executing stored procedures. A fairly common scenario I'd
think.

Anyway, at random points - or so far as we can determine, IIS reports that
access to SQL server was not found or access denied. This condition will
persist until you restart IIS after which everything resumes working as
expected.

I've verified that the machines have the same mdac version, .net version,
and we've even looked for stuck open connections. I've recently setup an
entirely new domain with clean installs and the same behavior occured. There
are no error messages logged in SQL or IIS - or the event logs for either
machine.

Where else can I go with this? This feels like a fairly generic error and
the apparent random nature hints that there is a specific set of conditions
that have to be met to repro the issue - but I can't identify them as yet.

Thanks for reading and a special thank you for your valuable time.

Chris

When the problematic behaviour is occuring, what do you see in SQL Server
Profiler? Is anything going across the network at all to SQL Server?

Have you used IISState to see what's happening inside IIS?

Cheers
Ken


"Chris Keller" <ChrisKeller RemoveThis @discussions.microsoft.com> wrote in message
news:F4C7B741-C841-409B-82D9-064AC5232DDE@microsoft.com...
 > Hello All,
 >
 > I'm looking for additional troubleshooting ideas on a persistant problem
 > that is cropping up 'randomly' when a web service is communicating with
 > the
 > SQL server.
 >
 > Both machines are running win2k Server with the most recent service packs
 > +
 > .NET 1.1. The Web Service provides data to client software by connecting
 > to
 > the SQL server and executing stored procedures. A fairly common scenario
 > I'd
 > think.
 >
 > Anyway, at random points - or so far as we can determine, IIS reports that
 > access to SQL server was not found or access denied. This condition will
 > persist until you restart IIS after which everything resumes working as
 > expected.
 >
 > I've verified that the machines have the same mdac version, .net version,
 > and we've even looked for stuck open connections. I've recently setup an
 > entirely new domain with clean installs and the same behavior occured.
 > There
 > are no error messages logged in SQL or IIS - or the event logs for either
 > machine.
 >
 > Where else can I go with this? This feels like a fairly generic error and
 > the apparent random nature hints that there is a specific set of
 > conditions
 > that have to be met to repro the issue - but I can't identify them as yet.
 >
 > Thanks for reading and a special thank you for your valuable time.
 >
 > Chris
 ><!-- ~MESSAGE_AFTER~ -->