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.
- We support SQL Server 2012R2, SQL Server 2014 and SQL Server 2016
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.