We have a third party web application that runs on iis7 (Windows Server 2008) against a SQL Server 2005 database on a different server. The SQL Server is behind our ISA2006 firewall; iis is on the other side. Every night at midnight it goes into a timeout and will not run again until I - believe this or not - completely recreate the database. I know that doesn't make sense, but it's the only thing I've found that works.The database is small (500 MB), and it works fine, so I don't think the problem is there. There is noting in the logs, except the imeout itself, and nothing is scheduled for that time.

Hi, This issue can be mainly related to IIS or SQL Server. Therefore, we are not the best resource to troubleshoot it. I suggest discussing this issue in our IIS or SQL Server forum. IIS forum: http://forums.iis.net/ SQL Server forum: http://social.msdn.microsoft.com/forums/en-US/category/sqlserver/ I hope your issue can be resolved soon. Tim Quan - MSFT