Using SQL Monitor with IIS
Published 03 December 2012
Once you've installed IIS, SQL Monitor's application pool must be mapped to .NET 2.0, and not .NET 4.0.
ASP.NET
SQL Monitor is an ASP.NET application. Some default installation of IIS do not enable ASP.NET; check that your IIS server has ASP.NET enabled before installing SQL Monitor.
For more information about ASP.NET troubleshooting, see Issues with IIS and ASP.NET.
For IIS 7
Before you install, make sure your account permissions have Full Control over the folders described in SQL Monitor Web Service account.
- Run the SQL Monitor installer on your IIS server, and select Use existing IIS Web Server.
- Select a destination folder for the SQL Monitor website.
All the files for the SQL Monitor website will be extracted to this folder.
- After completing installation, use IIS Manager to add the SQL Monitor website:
- Select Add web site and choose a name for the website.
- Enter the physical path for the website folder - this is the location of the website folder specified during installation of SQL Monitor.
- Specify an available port number and apply any other options, such as binding or certification that you need.
- Click Change .NET Framework Version and select v2.0.50727 from the drop-down list.
- Click Browse to test that the website is working; you should see the SQL Monitor front page.
A new application pool is automatically created for the SQL Monitor website. If you want to add SQL Monitor to an existing application pool, edit the Advanced properties for the site to change its application pool.
Read more about setting up your IIS website (Microsoft KB article)
For IIS 6
Before you install, make sure your account permissions have Full Control over the folders described in the page Account permissions required (in the section "SQL Monitor Web Service account").
- Run the SQL Monitor installer on your IIS server, and select Use existing Web Server.
- Select a destination folder for the SQL Monitor website.
All the files for the SQL Monitor website will be extracted to this folder.
- After completing installation, use IIS Manager to add the SQL Monitor website:
- Right-click Web Sites and click New > Web site.
- In the Web Site Creation Wizard, type the name of the website (for example "SQL Monitor") in the Description box.
- Enter the IP address of your IIS server and specify an available port (80 is the default port).
- Leave the Host header box empty, unless you have a specific requirement for a host header.
- In the Web Site Home Directory page, copy the path you specified in the SQL Monitor installer into the Path box (by default, this is: C:\Program Files\SQL Monitor 3\Website)
- Ensure that Allow anonymous access to this Web site is checked. SQL Monitor requires anonymous access to the website. For more information, see How to configure IIS Web site authentication in Windows Server 2003.
- Leave the default permissions on the Web Site Access Permissions page.
- SQL Monitor is an ASP.NET MVC application that uses URLs without extensions. You need to configure the site to use wildcard mapping, and make sure the correct ASP.NET version is selected:
- Right-click the Monitor website you just created and click Properties.
- Go to the ASP.NET page and select ASP.NET version v2.0.50727 from the drop-down list.
- Go to the Home Directory page and click Configuration. (If you have set SQL Monitor to be a virtual directory beneath an existing website, then go to the Virtual Directory page).
- Under Wildcard application maps, click Insert.
- In the Add/Edit Application Extension Mapping dialog, type the path to the aspnet.isapi.dll file in the Executable box. This should be mapped to
C:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll
or, for 64 bit Windows, toC:\windows\Microsoft.NET\Framework64\v2.0.50727\aspnet_isapi.dll
. - Ensure that Verify that file exists is not checked.
- Reload the SQL Monitor page to check that it displays correctly.
Moving from SQL Monitor Web Server to IIS
If you already have SQL Monitor installed and are using the default XSP web server, you can later move hosting to IIS by doing the following:
- Ensure that there is an IIS Web Server installed on the machine, and that ASP.NET v2.0.50727 is enabled.
- Run the SQL Monitor installer and select Use existing Web Server.
- On the Set up Web Server page, browse to and select the existing XSP web server file path as the install location for the IIS web server files. By default, these are located in:
C:\Program Files\Red Gate\SQL Monitor 2\Web
- Complete the installation by following the remaining instructions for IIS 7 or IIS 6 above.
- Stop the XSP server. To do this, go to Services (in XP, Start > All Programs > Administrative Tools > Services) and stop SQL Monitor Web Service.