Changing the Port for the SQL Monitor Web Service

This article will help you change the port used by the SQL Monitor Web Service (the provided webserver).
NOTE: You will need to update the port in the registry entry as described at the bottom of this page otherwise the web service port will show as in use during subsequent runs of the SQL Monitor installer.

 

To update the port in SQL Monitor v12 and later please follow these steps:

  1. Stop the SQL Monitor Web Service service
  2. Edit the Webserver.Kestrel.config file from the website installation directory (%ProgramFiles%\Red Gate\SQL Monitor\Web by default).
    Find the <url> tag within the <http> tag and change the port used in the URL:
    <http>
    <url>http://*:8080</url>
    </http>
  3. Restart the SQL Monitor Web Service service. 

For enabling HTTPS and other related functionality on the built-in webservice (a Kestrel webserver) see https://documentation.red-gate.com/sm/installing-and-setting-up/planning-the-sql-monitor-infrastructure-and-installation/configuring-https-for-the-default-sql-monitor-web-server

If the SQL Monitor is hosted in IIS, you will need to change the port bound to the site in the Bindings menu for that site in the IIS Manager - see https://docs.microsoft.com/en-us/iis/configuration/system.applicationhost/sites/site/bindings/ 

 

For v11 and earlier:

  1. Stop the SQL Monitor Web Service service
  2. Edit the RedGate.SqlMonitor.Service.Web.IisExpress.exe.config file from the website installation directory (%ProgramFiles%\Red Gate\SQL Monitor\Web\ by default).
    Find the portNum​ setting in the <serverSettings> tag:
    <serverSettings portNum="8080" serviceType="network">
    <website path="C:\Program Files\Red Gate\SQL Monitor\Web\Website\"/>
    </serverSettings>
  3. Restart the SQL Monitor Web Service service. 

 

Updating the registry entry used by the installer

  1. Open regedit.exe
  2. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Monitor 12\Install
  3. Update the Value HttpServerPort with the new port number

 

Was this article helpful?

0 out of 4 found this helpful
Have more questions? Submit a request