External SQL Database

With the default installation of Login Enterprise we make use of an internal Database. However we also deliver the option of configuring an external SQL database.

IMPORTANT NOTE: Before we begin there are a few things we need to know / do:

• You can only move to an External SQL Database and not back. To go back to an internal database you will need to re-install Login Enterprise completely and lose all data in the process
• When moving to an  External SQL Database will delete all existing data that has been collected until that time
• Please create a snapshot before starting the migration to eliminate to possibility of permanently losing data. 
• You need to create a database for Login Enterprise yourself, the account should be DBO.
• It is recommended to create a specific database service user for the Login Enterprise database, this must be a SQL user and not AD user. 
• SQL Server 2016 and higher, and Windows Server 2016 and higher are supported
• Make sure Named Pipes are enabled on the SQL Server Service

Configuration

To configure the External SQL Database we will need to go to the system page of Login Enterprise:

Once the page is opened click on the "Database Configuration" tab.

You are presented with list of items we need to configure in order to get things working;

• Database server hostname - hostname / IP / FQDN of SQL server
• Database server port number - Port number used to communicate to the SQL server
• 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

Once configured you can test the connection and save the DB configuration.