The SQL Server Database Configuration Tool allows you to connect the Apex One server to another existing Apex One SQL database and change the logon credentials used to connect to your existing database.
The Apex One SQL Server Database Configuration console opens.
Apex One automatically creates an instance for the Apex One database when SQL Server installs. When migrating to an existing SQL Server or database, type the preexisting instance name for the Apex One instance on the SQL Server.
When using the Windows Account to log on to the server, Apex One applies the User name of the currently logged on user.
The user account must belong to the local administrator group or Active Directory (AD) built-in administrator and you must configure the following User Rights Assignment policies using the Windows Local Security Policy or Group Policy Management console:
Log on as a service
Log on as a batch job
Allow log on locally
The user account must also have the following database roles:
Click SQL Database Unavailable Alert… to configure the SQL database notification settings.
For details, see Configuring the SQL Database Unavailable Alert.
Click Test Connection to verify the authentication credentials for the existing SQL Server or database.