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).

  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/installation-and-setup/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. 

 

Was this article helpful?

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