SQL Monitor 12

Moving from SQL Monitor Web Server to IIS

If you already have SQL Monitor installed and are using the self-contained Web Server, you can later move hosting to IIS.

Once you have installed IIS, make sure that ASP.NET is installed and enabled. See: Problems with IIS and ASP.NET.

Configuring an existing IIS Web Server

Use IIS Manager (see How to Open IIS Manager) to carry out the changes described below.

If ASP.NET Core Module for IIS is not already installed, it must be installed and IIS restarted afterwards.

Configuring IIS

  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 self-contained website folder you specified during installation of SQL Monitor. By default this is:

    C:\Program Files\Red Gate\SQL Monitor\Web

  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)

Stopping the self-contained Web Server

To stop the self-contained server, display Windows Services (select Start > Run, enter services.msc and click OK) and stop SQL Monitor Web Service.

It is possible to keep both IIS and self-contained Web Servers on the same machine. You can uninstall the SQL Monitor Web Service but, for testing purposes, it may prove useful to restart the self-contained Web Server should you have any problems with the IIS configuration.

Didn't find what you were looking for?