Setting up an encrypted database connection

Email Log Server Configuration Utility Help | TRITON AP-EMAIL | Version 8.2.x

You can choose to encrypt the database connection during email product installation. If you did not select this option at product installation, you can configure an encrypted connection in the Log Server Configuration utility.

By default, Email Log Server uses NTLMv2 to encrypt the connection.


	Important If you want to use SSL encryption, you must have imported a trusted certificate to the Log Server machine. See your database documentation for information about importing a trusted certificate.

The Bulk Copy Program (BCP) option for inserting records into the Log Database in batches cannot be used. Not using the batch method may affect Log Database performance.

The connection from the Email module on the TRITON Manager to an email appliance cannot be encrypted. If you enable encryption for Log Database, you must disable the SQL Server force encryption feature. See your Microsoft SQL Server documentation for details.

Click the Connection button on the Database tab of the Email Log Server Configuration utility to create a new data source. Use the following steps to establish an encrypted database connection:

In the Select Data Source dialog box, select the Machine Data Source tab.

Click New to open the Create New Data Source dialog box.

Select the System Data Source option and click Next.

Select SQL Server and click Next.

In the Create a New Data Source to SQL Server dialog box, enter a name and description for your new data source in the Name and Description fields.

Select the SQL Server to which you want to connect in the Server drop-down list and click Next.

Choose SQL Server authentication.

Ensure the Connect to SQL Server check box is marked and enter the appropriate SQL Server login ID and password. Click Next.

Change the default database to your new data source by marking the Change the default database to check box and selecting the database in the drop-down list. Click Next.

10.

Mark the Use strong encryption for data check box.

11.

Click Finish.

12.

Stop and restart Log Server via the Connection tab after making this and any other changes in the configuration utility. (See Stopping and starting Log Server.)