SQL Monitor 5

Configuring SQL Monitor with IIS 6

This page explains how to set up SQL Monitor with IIS 6. For later versions of IIS, see Configuring SQL Monitor with IIS 7 and later.

SQL Monitor doesn't install IIS.

If you don't already have a IIS web server, we recommend you install the SQL Monitor web server instead of following these instructions. For more information, see Choosing the web server.

1. Before you start

  1. Make sure your IIS server has ASP.NET enabled. If you installed IIS using Add or Remove Programs or the Configure Your Server wizard, ASP.NET should be enabled already. For more information, see Problems with IIS and ASP.NET.
  2. Make sure your IIS service account has full control over the folders listed under web service account on the Permissions page.
  3. If you've already installed SQL Monitor, stop the SQL Monitor web service:
    1. From the Start menu, open services.msc.
    2. In the list, select the SQL Monitor web service and click the stop button in the toolbar.

2. Install SQL Monitor to use with IIS

If you've already installed SQL Monitor, skip this section. 

For more information about installing SQL Monitor, see Installing.

  1. Run the SQL Monitor installer on your IIS server and follow the steps until you reach the Choose web server page. 
  2. Select I'll use an IIS web server:
  3. Click Next.
  4. On the Installation options page, under Install web interface files to, enter a folder to extract the website files to.
  5. Follow the SQL Monitor installer steps until you reach the Add the SQL Monitor website to your web server page:

    Don't click Finish yet – we'll come back to the installer later.

3. Configure the SQL Monitor website

  1. In IIS Manager, on the left, under the IIS server you want to use, right-click Web Sites and select New > Web Site:

    The Web Site Creation Wizard opens. 
  2. Click Next.
  3. In Description, enter the name of the website (eg SQL Monitor) and click Next.
  4. Enter the IP address you want to use for the SQL Monitor website and an available port (the default is 80). 
    Unless you need it, leave the Host header box empty.
  5. Click Next.
  6. Enter the path to the location of the SQL Monitor website files. By default, this is C:\Program Files\Red Gate\SQL Monitor 5\Web
    If you're installing SQL Monitor, you can copy the path from the SQL Monitor installer:
  7. Make sure Allow anonymous access to this Web site is checked.

    For more information about anonymous access, see How to configure IIS Web site authentication in Windows Server 2003.
  8. Click Next.
  9. On the Web Site Access Permissions page, make sure that only Read is selected:
  10. Click Next and then Finish.
  11. On the left, right-click the Monitor website you created and click Properties.
    The Properties window opens.
  12. On the ASP.NET tab, open the ASP.NET version dropdown.
    If you're using SQL Monitor 4.3 or later, select ASP.NET version 4.0.30319.
    If you're using an earlier version of SQL Monitor, select ASP.NET version 2.0.50727.
  13. On the Home Directory tab, click Configuration.
  14. Under Wildcard application maps, click Insert.
  15. In the Add/Edit Application Extension Mapping window, enter the path to the aspnet.isapi.dll file in the Executable box.

    If you're running SQL Monitor 4.3 or later

    If you're running 32-bit Windows, the executable path should be: C:\windows\microsoft.net\framework\v4.0.30319\aspnet_isapi.dll
    If you're running 64-bit Windows, the executable path should be: C:\windows\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll

    If you're running an older version of SQL Monitor

    If you're running 32-bit Windows, the executable path should be: C:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll
    If you're running 64-bit Windows, the executable path should be: C:\windows\Microsoft.NET\Framework64\v2.0.50727\aspnet_isapi.dll

  16. Make sure Verify that file exists is not checked:
  17. Click OK to close each dialogue.
  18. To make sure the website works, in your browser, go to IP:PORT NUMBER (eg localhost:80).

4. Finish

  1. To test the configuration, in IIS Manager, on the right, under Actions, click Browse.
    This opens the SQL Monitor website in your default browser.
  2. If you're installing SQL Monitor, in the installer, select the I've added the SQL Monitor web interface to my web server checkbox and click Finish.

SQL Monitor is now set up with IIS.

Didn't find what you were looking for?