Application Pool trouble connecting database

Giganews Newsgroups
Subject: Application Pool trouble connecting database
Posted by:  Jaap (jan.sonnema…@gmail.com)
Date: Thu, 12 Jul 2007

Sometimes when the W2003 is restarted the IIS applications cannot
connected to MSSQL.

When the Application Pool is manually stopped and again started the
connection to MSSQL succeeds.
(Recycle this Application Pool doesn't give this result.)

I think this has to do with IIS requests from visitors during
restarting with an IIS service started but the MSSQL is not yet ready.
Via the Application Pool a MSSQL connection is being initiated, but
failes. This state remaines until manual stop/start the pool.

Does anyone has a solution to this problem?

Jaap

Replies