Problems with IIS and ASP.NET
Published 07 October 2020
SQL Monitor is an ASP.NET application. Some default IIS installations don't enable ASP.NET.
If you installed ASP.NET using the Add or Remove Programs dialog or the Configure Your Server Wizard, ASP.NET should be automatically enabled in IIS.
If you installed it as part of another application, downloaded it from the web, or installed it prior to installing IIS, you must enable ASP manually. Before you install SQL Monitor, make sure your IIS server has ASP.NET enabled.
To change ASP.NET settings, use IIS Manager.
For more information, see ASP.NET and IIS Configuration in the Microsoft documentation.
Enabling ASP.NET impersonation
IIS needs to provide a Windows identity to access protected Windows resources or files or database servers. ASP.NET also needs access to these, but by default it doesn't use the same Windows identity.
You need to configure ASP.NET to impersonate the IIS Windows identity. For instructions to do this in IIS 6, see Impersonation in ASP.NET (IIS 6) in the Microsoft documentation. For instructions to do this in IIS 7, see Configure ASP.NET Impersonation Authentication (IIS 7).
If you're using SQL Monitor with IIS, SQL Monitor's application pool must be mapped to .NET 4.0.
SQL Monitor requires the following security permissions to be enabled in IIS 7:
- anonymous authentication.
- forms authentication.
In IIS 7.5, security has been tightened so that w3wp.exe (the IIS application pool process) runs by default under the ApplicationPoolIdentity account. In Windows Server 2008 R2 and Windows 7 this is a Managed Service Account. Managed Service Accounts are a new concept in Win 7 / Windows 2008 R2. For more information, read the following article:
ApplicationPoolIdentity account does not necessarily have access permissions to the SQL Monitor website files that are installed by default to
%ProgramFiles%\Red Gate\Sql Monitor\Web. You can fix this by manually giving permissions to the SQL Monitor website folder. To do this, run the following command:
C:\>icacls "C:\Program Files\Red Gate\SQL Monitor\Web" /grant "IIS APPPOOL\Monitor":(OI)(RX)
IIS APPPOOL\Monitor is the Managed Service Account automatically generated for the Monitor application pool; the Monitor application pool is created automatically when adding a website called Monitor.
In IIS Manager, go to the Monitor website, double-click Authentication and then set Anonymous Authentication to use Application Pool Identity (i.e
IIS APPPOOL\Monitor) rather than IUSR (IUSR is the default user identity for anonymous authentication).
SQL Monitor will not work with any application pool using Classic Managed Pipeline Mode. You will need to ensure that SQL Monitor is added to an application pool running Integrated Pipeline mode.
HTTP Error 500.19 – Internal Server Error messages
The SQL Monitor Web Server may display the following message (where
### is the identifier for that specific error):
HTTP Error 500.19 - Internal Server ErrorHRESULT: 0x80070### Description of HRESULT The requested page cannot be accessed because the related configuration data for the page is invalid.
You can find possible causes and solutions for errors by checking the
HRESULT identifier against the list here: http://support.microsoft.com/kb/942055.