SQL Monitor 2

Using SQL Monitor with IIS

SQL Monitor does not install IIS. If you do not have an existing IIS Web Server, you will need to install the SQL Monitor Web Server. See the Installing SQL Monitor components.

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.

  1. Run the SQL Monitor installer on your IIS server, and select Use existing IIS Web Server.
  2. Select a destination folder for the SQL Monitor website.

    All the files for the SQL Monitor website will be extracted to this folder.

  3. After completing installation, use IIS Manager to add the SQL Monitor website:
    1. Select Add web site and choose a name for the website.
    2. Enter the physical path for the website folder - this is the location of the website folder specified during installation of SQL Monitor.
    3. Specify an available port number and apply any other options, such as binding or certification that you need.
    4. 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 SQL Monitor Web Service account.

  1. Run the SQL Monitor installer on your IIS server, and select Use existing Web Server.
  2. Select a destination folder for the SQL Monitor website.

    All the files for the SQL Monitor website will be extracted to this folder.

  3. After completing installation, use IIS Manager to add the SQL Monitor website:
    1. Right-click Web Sites and click New > Web site.
    2. In the Web Site Creation Wizard, type the name of the website (for example "SQL Monitor") in the Description  box.
    3. Enter the IP address of your IIS server and specify an available port (80 is the default port).
    4. Leave the Host header box empty, unless you have a specific requirement for a host header.
    5. 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 2\Website)
    6. Ensure that Allow anonymous access to this Web site is checked. SQL Monitor requires anonymous access to the website. For more information about website authentication, please read the following Windows KB article for more information: http://support.microsoft.com/kb/324274  (How to configure IIS Web site authentication in Windows Server 2003).
    7. Leave the default permissions on the Web Site Access Permissions page.
  4. SQL Monitor is an ASP.NET MVC application that uses URLs without extensions, so you will need to use wildcard mapping:
    1. Right-click the Monitor website you just created and click Properties.
    2. In the Properties dialog, 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).
    3. Under Wildcard application maps, click Insert.
    4. 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, to C:\windows\Microsoft.NET\Framework64\v2.0.50727\aspnet_isapi.dll.
    5. Ensure that Verify that file exists is not checked.
    6. 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:

  1. Ensure that there is an IIS Web Server installed on the machine, and that ASP.NET is enabled.
  2. Run the SQL Monitor installer and select Use existing Web Server.
  3. 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

  4. Complete the installation by following the remaining instructions for IIS 7 or IIS 6 above.
  5. Stop the XSP server. To do this, go to Services (in XP, Start > All Programs > Administrative Tools > Services) and stop SQL Monitor Web Service.

Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?