SQL Monitor 13

Moving the Base Monitor to a different machine

Suppose you want to disable the machine where the Base Monitor service is running but don't want to stop monitoring data. In that case, you can install the Base Monitor on another machine and change the connection in SQL Monitor Web UI.

If you want to migrate the database, see Moving the data repository to a different machine.

For more details on how to use the installer, see Configuring the Base Monitor Service and SQL Monitor database.

General overview

To move the Base Monitor to a different server, the following steps need to be performed:

  1. Download the base monitor installer,
  2. Stop the Base Monitor on a server that you want to decommission,
    To do this, go to Services (select Start > Run, enter services.msc and click OK) and stop SQL Monitor Base Monitor.
  3. Optionally, move the data repository (database) to a different server using the backup and restore procedure, as described in Moving the data repository to a different machine,
  4. Move the content of the %ProgramData%\Red Gate\SQL Monitor folder to the new machine,
  5. Install the Base Monitor on a new machine, choosing the existing database as a data repository,
  6. Update the Base Monitor connection in the SQL Monitor Web UI.

Downloading the base monitor installer

  1. In the Configuration page, under Advanced, select Base Monitors:
  2. Click the Base Monitor installer link to download the SQLMonitorBaseMonitorInstaller.exe file:

Installing the Base Monitor on another machine

  1. Run the .exe file of the base monitor installer downloaded previously.
  2. Click Next to display the Set up Base Monitor page.
  3. Specify where to install the files that will run the service.
  4. Select a TCP port to use for communicating with the Web Server and the data repository. Click Next.

Using an existing database for the Data Repository

Do not configure two base monitors to use the same data repository simultaneously. It risks data corruption.

To specify your Data Repository database:

  1. Click Set Up Data Repository and then select Use an existing database.
  2. Click Next, then select the SQL Server instance.
  3. In the Database box, select the database you want to use; databases on the SQL Server should be automatically detected, and appear in the list.
    You can type an instance name or IP address directly into the Server box if the instance name does not appear in the drop-down list. 
  4. Click Next. SQL Monitor checks the database. Once the database connection has been confirmed, click Close.

If you encounter an error message when connecting to the database, see Permissions required for the SQL Monitor Service accounts.

Changing the Base Monitor connection

Once you've installed the Base Monitor on another machine, you need to change the connection.

If you're changing the primary base monitor (the one appearing first on the list of Base Monitors, it stores the auth config):

  1. Open SQL Monitor Website, logging in (RDP) to the machine that hosts it (localhost),
  2. Set the base monitor location as the new address of the new Base Monitor:
  3. Click Save base monitor location.


If you're changing an additional (secondary) base monitor:

  1. Using SQL Monitor Website, go to Configuration > Base Monitors,
  2. Click Add additional base monitor:
  3. Enter the full domain name or IP address for the machine that has the Base Monitor installed on it,
  4. Select the TCP port you specified during installation to use for communicating with the Web Server and the data repository,
  5. Click Save connections.

Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?