How do you use cloud databases? Take the survey.

Internal Server Error in IIS 7.5 after upgrade to SQL Monitor 7.0.9

This morning I upgraded our SQL Monitor from 7.0.4 to 7.0.9. The upgrade ran as normal, with no apparent issues. However, after the upgrade, I get an HTTP Error 500.0 Internal Server Error after I log in and try to access the Global Dashboard.

We're running it on Windows Server 2008 R2 with IIS 7.5. It was running perfectly fine with version 7.0.4. I verified the IIS settings against the SQL Monitor documentation, and nothing appears to have changed. IISReset and rebooting the server seemed to make no difference, nor did uninstalling and reinstalling the SQL Monitor Web application.

Comments

  • Support pointed me toward the solution:

    Starting with 7.0.6, the account under which the IIS Application Pool for the SQL Monitor website is running must have direct access to SQL Monitor's database. In my case, I had the SQL Monitor application pool set at its default identity "ApplicationPoolIdentity". I changed it to use the same AD credentials that SQL Monitor uses to connect to its database, and everything immediately started working.
Sign In or Register to comment.