External SQL Database

Overview

Why use an external SQL database?

External SQL database requirements

Configuring external SQL database

Overview

By default, Login Enterprise is delivered using an internal database. However, starting from Login Enterprise 4.3, you can add an external SQL database.

Before you choose to migrate to an external SQL database in Login Enterprise, there are several things you need to consider:

  • Migrating to an external SQL database is a one-way process. If you choose to go back to the internal database, your data will not be transferred back into the internal database and you will have data loss.
  • Migrating to an external SQL database will result in the deletion of all existing data collected up to that point.

Before migrating to an external SQL database, please create a snapshot to eliminate the possibility of losing data permanently.

Why use an external SQL database?

Migrating to an external SQL database offers several advantages for enhanced performance, scalability, and centralized management. External databases provide better scalability options, enabling Login Enterprise to handle increased data volumes and user loads more efficiently. With centralized management, database administrators can monitor and optimize the database separately, ensuring better control and streamlined maintenance of Login Enterprise. Additionally, external databases often come with robust features like high availability, redundancy, and advanced security measures, contributing to improved data integrity and protection for Login Enterprise. The flexibility to integrate seamlessly with various platforms and applications, along with simplified compliance with regulations, makes the move to an external SQL database a strategic choice for optimizing the efficiency of Login Enterprise and ensuring long-term viability.

External SQL database requirements

For the successful external SQL database implementation in the Login Enterprise user interface, there are several requirements:

  • Login Enterprise is compatible with Microsoft SQL Server 2016, 2017, and 2019
  • A database must exist on the SQL Server instance.
  • The SQL database connection requires an SQL user, not a Domain User.
  • Ensure that Named Pipes are enabled for the SQL Server service
  • The connection can be configured to utilize SSL when communicating with the SQL Server.

The minimum requirement for external SQL is the same as the default size of the appliance, or the minimum requirement for the version of the SQL you choose, whichever is greater.

Appliance Default:

Configuration CPU Memory Disk
Recommended 4(v)CPU 8GB RAM 100GB


Configuring external SQL database

To configure the external SQL database in the Login Enterprise user interface:

  1. Log in to the Login Enterprise with your credentials.
  2. In the Sidebar menu, navigate to Other > System.

Frame 19 (1).png

3. In System, click Database configuration.

Frame 20.png

4. In the Database configuration window, fill out the following details:

Field Value
Database server hostname Hostname / IP / FQDN of SQL server
Database server port number The port number used to communicate to the SQL server
SSL/TLS settings
  • Select Enable SSL to enhance the security of your connection by encrypting the data exchanged between the appliance and the SQL server. This is the recommended choice to protect sensitive information during transmission.
  • Select Ignore SSL errors to allow the connection to proceed even if there are SSL-related issues.
Database instance name The name of the preferred instance for the database configuration
Database name The name of the created database
Username The username of the preferred SQL user
Password The password of the SQL user

 

image 47.png

5. Click Test connection to ensure the database is correctly configured.

6. Click Apply DB config to save the database configurations.

Congratulations, you have successfully configured your external SQL database to use with the Login Enterprise.