Page History

The Uptime Infrastructure Monitor DataStore can run on a Microsoft SQL Server database to leverage existing SQL Server installations and take advantage of SQL Server's advanced replication, recovery and archiving options. This article assumes that you have already installed Uptime Infrastructure Monitor and have a SQL Server database available. For more information,  see Supported databases in UIMUptime Infrastructure Monitor.

Step 1: Preparing your MS SQL Database

To run UIM with a SQL Server database, first create a database on your SQL Server default instance that UIM will be able to use. If you are unsure which databases are available to you or how to create a new database, please contact your database administrator and have a database configured for UIM.

...

Step 2: Configuring UIM

After you have created the SQL Server database and set up the UIM database, you need to configure UIM to access the new database. This involves editing these two configuration files (replace <uptime_dir> with the directory of your UIM install):

...

Next you will need to modify the up.time Controller service configuration file in the same manner. This service provides UIM with API services and is an ingress point for most of the Gadgets in the Dashboards. Update the <uptime_dir>\controller\resources\uptime_controller.conf file just as you did the uptime.conf file, commenting out the MySQL configuration lines, un-commenting the MS SQL related lines and editing them with the appropriate configuration and credential info. 

Step 3: Resetting the UIM DataStore

Reset the up.time DataStore settings to create the tables and default values required by UIM on your SQL Server database. Make sure the "up.time Data Collector" and "up.time Controller" services are stopped before run the following command on your UIM monitoring station:

...

<uptime_dir>\resetdb really

Step 4: Restarting UIM

After the resetdb utility has finished updating your database settings, start the "up.time Data Collector" and "up.time Controller" services. When Uptime Infrastructure Monitor starts, it will be running from your SQL Server database with an empty Uptime Infrastructure Monitor installation.

Step 5: Disabling the UIM DataStore service

Now that UIM is successfully started and running from your MS SQL database, we no longer need to have the local MySQL datastore, which means that we can disable the unneeded service to free up some resources on the monitoring station itself.

...