Changing the Log Database

The Log Database may need to be changed when one of the following situations occurs:

  • The database IP address changes.
  • The database username and password change.
  • The user wants to change authentication settings.
  • The user wants to use a named instance.

This type of change must be made in two locations: on the page Settings > Reporting > Log Database and in the Email Log Server Configuration wizard.

Use the following steps to change the Log Database configuration:

Steps

  1. Enter the IP address for the new Log Database on the page Settings > Reporting > Log Database, in the Log database field.
  2. Open the Email Log Server Configuration wizard for the Windows machine on which Log Server is installed (Start > Forcepoint > Email Log Server Configuration).
  3. In the Database tab, click Connection to open the Select Data Source dialog box.
  4. Select the Machine Data Source tab and click New to open the Create New Data Source dialog box.
  5. Select System Data Source (Applies to this machine only), and click Next.
  6. Select SQL Server and click Next.
  7. Click Finish.
  8. In the Create a New Data Source to SQL Server dialog box, enter the server name, description, and IP address of the new SQL Server database in the Name, Description, and Server entry fields and click Next.
  9. Select With SQL Server authentication using a login ID and password entered by the user.
  10. Enter the username (sa) and a password and click Next.
  11. In the p ull-down menu Change the default database to, select the esglogdb76 database and click Next.
  12. Click Finish.
  13. In the ODBC Microsoft SQL Server Setup dialog box, click Test Data Source to test the server connection.
  14. Click OK.
  15. Enter the new username and password in the SQL Server Login dialog box.
  16. In the Email Log Server Configuration wizard Database tab, notice that the ODBC Data Source Name (DSN) field contains the new server name, and click Apply to confirm the new configuration.
  17. Click OK in the warning message. The Log Server must be stopped and restarted for the new settings to take effect.
  18. In the Email Log Server Configuration wizard Connection tab, click Stop to stop the Log Server service.
  19. In the same tab, click Start to restart the Log Server service. The new database settings are in effect.