Internal Server Error in IIS 7.5 after upgrade to SQL Monitor 7.0.9
zefzephyran
Posts: 3
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.
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
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.