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.
Configuring external SQL database
To configure the external SQL database in the Login Enterprise user interface:
- Log in to the Login Enterprise with your credentials.
- In the Sidebar menu, navigate to Other > System.
3. In System, click Database configuration.
4. In the Database configuration window, fill out the following details:
|Database server hostname
|Hostname / IP / FQDN of SQL server
|Database server port number
|The port number used to communicate to the SQL server
|Database instance name
|The name of the preferred instance for the database configuration
|The name of the created database
|The username of the preferred SQL user
|The password of the SQL user
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.