Navigation:  Getting Started > Settings > Database Configuration

SQLite Database

This is a file-based database, it is easily set up and provides all of the functions of a full fledged database. However, if the file grows beyond several hundred megabytes, its performance suffers.

You can choose an existing database file using the "..." button in the Options panel. Creating a new empty database file is accomplished by clicking the other button.

ServerSentinel will show you an information message recommending a switch to a database that can handle large datasets more efficiently if the file size exceeds 300 MB. You should then export your configuration, configure a new database, add the library extensions to it and import your settings into the new database again.

 

MS-SQL Database

Use this driver to connect to a MS-SQL Database. 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 here.
You need to create a new empty catalog and grant access to it for a user with SQL Server Authentication enabled.

The test button allows you to check whether the database connection could be correctly established.

It is not possible to use Windows Authentication (SSPI) here, since the ServerSentinel service usually operates with different credentials (local system per default) which in general doesn't have the required permissions.

 

MySQL Database

If you want to configure ServerSentinel against a MySQL Database, no additional drivers are required.

However, you need to have access to a configured MySQL database.

 

Note: If you install a new version of ServerSentinel and want to use an "old" database, you have to configure the "old" database in the setup so that the ServerSentinel will update the database.