Define a production database

Use the UserLock console to configure a new production database connection.

Published September 25, 2025

Introduction

By default, UserLock ships with a lightweight database that is not designed for production.
To ensure performance and reliability, you should connect UserLock to a production-ready database.

Before following this guide:

Steps

To connect UserLock to a new production database:

  1. Prepare the database

    • Create an empty database in your SQL Server or MySQL environment.

    • See the Database reference for compatibility details.

  2. Open the database settings

    • In the UserLock console, click the ⚙️ wheel (top right).

    • In the left menu, select Database.

  3. Configure the connection

    • Select the appropriate Database type.

    • Enter the connection details (server, authentication, database).

    • Use an account with rights to read, write and create tables or if the Windows authentication is selected make sure that the Service impersonation account has these rights.

    • For a description of each field, see the Server settings ▸ Database reference.

  4. Validate and save

    • Click Test connection.

    • If successful, click Save.

Note

👉 Once saved, UserLock creates the required tables and immediately switches to the new database.


⚠️ Since ODBC Driver 18 for SQL Server, the server certificate needs to be validated by default for encryption.
To bypass certificate validation and avoid connection issues, you can add the following option to the connection string:
TrustServerCertificate=yes
Alternatively, you can follow the Microsoft SQL Server documentation to properly configure your SQL Server installation.

Next steps

This guide shows the simplest way to point UserLock to a new production database.

For more advanced scenarios, see: