It is recommended to use an external database for storing configuration and user information when using Digital Access component. When you initially open the Manage System > Database Service page in Digital Access Admin, the database shown is the internal database. This article describes how to configure an external database.
When using an external database the "hag" database needs to be created manually. Read the vendor specific documentation on how to properly create a database. The required tables will be created automatically by Digital Access component.
Create database in MS SQL
Example using the MS SQL command line tool "SQLCMD":
CREATE DATABASE hag
NAME = dbName_dat,
FILENAME = 'C:\databases\hagdb\dbHag.mdf'
LOG ON (
NAME = dbName_log,
FILENAME = 'C:\databases\hagdb\dbHag.ldf'
Create database in MySQL
Example using the "MySQL Command Line Client":
mysql> create database hag;
Log in to Digital Access Admin
Log in to Digital Access Admin with an administrator account.
Configure database service
You can configure what database Digital Access component uses for storing users.
Prerequsite: Create the database first.
In Digital Access Admin, go to Manage System > Database Service.
In the Database drop-down list, select database. The list contains the default configurations for the supported databases. If you use other databases than the default ones, use the Advanced Fields, click ? for more help.
Enter Host and Name. The system will convert this information to the form shown in the Advanced Fields.
Enter User, Password and Retry Attempts, click ? for help.
If you want to configure a database not on the Database drop-down list, click Toggle Advanced Fields and enter Dialect, Url and Driver. Click ? for help.
When this page is saved it will save the information currently displayed. If the settings are saved while displaying the Standard Fields (Database, Host and Name) the information in the Standard Fields will be used, regardless of what manual changes has been made in the Advanced Fields. The same applies the other way around. If the page is saved while displaying the Advanced Fields the information in those fields will be used, regardless of what information might have been entered in the Standard Fields.
When done, click Save.
Check Copy all users when you want to copy all users from the current Database Service configuration to the one about to be saved.