Database Configuration

<< Click to Display Table of Contents >>

Navigation:  User Interface > Application Menu > Settings >

Database Configuration

Here you can configure the database the ServerSentinel service and application communicates with. With the option Select Database you can select which type of database you wish to use. Currently the following types are available:

SQLite Database (legacy)

This is a file-based database. It is easily set up, but provides less functionality than a full fledged database. If the file grows beyond several hundred megabytes, its performance suffers. Also no parallel access it possible.

Database File

Here you can select an existing database or enter a path to a non-existing file. ServerSentinel will then create a new database under the selected filename.

Note: The support for SQLite will be dropped in a future version.

Firebird Datebase

Use this option to use an embedded Firebird database.

Filename

Here you can select an existing database or enter a path to a non-existing file. If the database does not exist, ServerSentinel will create a new one under the selected filename.

MSSQL Database

Use this option to connect to a MSSQL Database on a Microsoft SQL Server. No additional drivers are required, however you need to have access to a configured Microsoft SQL Server or Microsoft SQL Express database. Get the Express Database for free from the Microsoft Site.

You can create a new empty catalog and grant access to it for a user which you want to use for the configuration or when you have a user with enough rights you can create a new catalog over the configuration.

Host

Here you can select the computer from your network on which Microsoft SQL Server is installed or enter the name or IP address of the computer manually.

If an instance name was used, it must be also specified (<host>\<instance name>). In case of a SQL Express database the instance name is 'SQLExpress'

Authentication

Here you can choose if you want to use Windows Authentication or SQL Server Authentication with username and password to access the Microsoft SQL Server.

Username

Here you can set the username which you want to use for authentication if you decided to use SQL Server Authentication.

Password

Here you can set the password associated with the username you want to use for authentication if you decided to use SQL Server Authentication.

Catalog

Hier you can select from the available catalogs which one you want to use with ServerSentinel or enter a new one and create it with the Create Database button.

Test Connection

With this button you can test your configuration for properness.

Create Database

With this button you can create a new catalog with the name new set under Catalog.

Regard that the set user must have enough rights to create a new catalog.

MySQL Database

If you want to configure ServerSentinel against a MySQL Database, choose this option. No additional drivers are required. However, you need to have access to a configured MySQL database.

You can create a new empty database and grant access to it for a user which you want to use for the configuration or when you have a user with enough rights you can create a new database over the configuration.

Host

Here you can select the computer from your network on which MySQL Server is installed or enter the name or IP address of the computer manually.

Port

Here you can set the port which is used by the MySQL Server for communication.

Username

Here you can set the username which you want to use for authentication.

Passwort

Here you can set the password associated with the username you want to use for authentication.

Database

Hier you can select from the available databases which one you want to use with ServerSentinel or enter a new one and create it with the Create Database button

Test Connection

With this button you can test your configuration for properness.

Create Database

With this button you can create a new database with the name new set under Database.

Regard that the set user must have enough rights to create a new database.