Procedure

1. On the Apex One server computer, browse to <Server installation folder>\PCCSRV\Admin\Utility\SQL.
2. Double-click SQLTxfr.exe to run the tool.
   The Apex One SQL Server Database Configuration console opens.
3. Specify the Server name as follows: <host name or IP address of the SQL Server>,<port_number>\<instance name>

   Important 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.

4. Provide the authentication credentials for the SQL Server database.
   • When using the Windows Account to log on to the server, Apex One applies the User name of the currently logged on user.

     Important 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: dbcreator bulkadmin db_owner

5. In the Database Name section, specify the Apex One database name on the SQL Server.
6. If you configured the Endpoint Sensor database during installation, specify the Endpoint Sensor database name.

   Note If you have the Endpoint Sensor database in a different SQL instance than the Apex One database, refer to the following Knowledge Base article on how to manage the database. https://success.trendmicro.com/solution/1122929

7. Optionally, perform the following tasks:
   • Click Apex One Database Unavailable Alert… to configure the Apex One SQL database notification settings.
     For details, see Configuring the Apex One Database Unavailable Alert.
   • Click Test Connection to verify the authentication credentials for the existing SQL Server or database.
8. Click Start to apply the configuration changes.