Moving from SQL Monitor Web Server to IIS
Published 21 October 2021
If you already have SQL Monitor installed and are using the self-contained Web Server, you can later move hosting to IIS.
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.
- 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 self-contained website folder you specified during installation of SQL Monitor. By default this is:
C:\Program Files\Red Gate\SQL Monitor\Web
- Specify an available port number and apply any other options, such as binding or certification that you need.
- 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.
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.