Specific site unable to connect to MSSQL server after reboot

sql-server windows-server-2008-r2 iis-7.5

Solution 1:

It's possible that on reboot IIS becomes available before the SQL Server database (i.e. it's in recovery and it not available). Do you have lot of databases? This could mean a longer start up time.

I'm guessing this by "Cannot open database "SiteDb" requested by the login" which means login is successful but can not connect to the database specified.

Ideas:

  • Can you change the IIS services to delayed start?
  • Set a start up job that waits 30 seconds then issues iisreset
  • Add retry logic to the web code?

Related

Why is the response truncated at 16k with php + fastcgi?
Tracking Avaya call volume via SNMP?
How to add a privilege to an account in Windows?
Active Directory customization and Human Resources management
How to restrict SSH /SFTP User to a sub folder of an apache website?
Ports below 1024
BSD 50% interrupt utilization in irq0/clock
AD: Roll out an MSI application at midnight
Draytek Vigor 2820 static IP's
What are the advantages/disadvantages of using cgroups?
KVM + cgroups: Dom0 process best practice?
How to script printer creation on a Windows Server 2008 R2 clustered print server?