Webiste conneciton to SQL Server hangs

From: si (si_at_discussions.microsoft.com)
Date: 01/31/05 

Date: Mon, 31 Jan 2005 02:11:15 -0800

I have an IIS 6.0 website that accesses a SQL Server 2000 database through an
asp page. I didn't write the website I just manage the IIS and SQL Server.

When the link to the asp page is clicked it should access the database and
return a drop down list. Instead, it hangs for a while and then returns a
blank page. If I click the refresh button it returns the correct page.

>From then on it works correctly for a while, but then the same thing occurs.
 It looks as though the database connection is blocked if it is not used for
a while.

Is there anything in SQL Server that would cause this behaviour?

Many Thanks