| Table of Contents |
|---|
Contents
The up.time 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 up.time and have a SQL Server database available (see Supported Databases for version details).
Step 1 - Preparing your MS SQL Database
...
To run up.time with a SQL Server database, first create a database on your SQL Server default instance that up.time 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 up.time. Currently, the up.time database is only supported on the default instance of the SQL Server, not a named instance.
...
| Note |
|---|
| The SQL Server database does not need to be on the same system as the up.time monitoring station. |
...
Step 2 - Configuring up.time
After you have created the SQL Server database and set up the up.time database, you need to configure up.time to access the new database.
To do this, edit the uptime.conf file (located in the up.time installation folder) add a # character at the beginning of each of the following lines:
| Code Block | |
|---|---|
| |
| |
dbDriver=com.mysql.jdbc.Driver dbType=mysql dbHostname=localhost dbPort=3307 dbName=uptime dbUsername=uptime dbPassword=uptime |
...