Email Log Server and Log Database settings

To update database connection settings for Forcepoint Email Security:

Steps

  1. Log on to Email Security modules of the Security Manager.
  2. Go to the Settings > Reporting > Log Database page and enter the IP address of the new SQL Server installation in the Log database field.
  3. (Optional) On the Settings > Reporting > Log Database page, under Partition Management, update the Data and Log File Path entries as needed.
    This ensures that new database partitions are created in the correct (new) location. Do not follow this step if you intend to place database partitions in the old location.
  4. Click OK (in the Log Database Location area of the screen).
  5. On the machine running Email Log Server, start the Email Log Server Configuration utility (Start > All Programs > Forcepoint > Forcepoint Email Security > Email Log Server Configuration).
    See Email Log Server Configuration Utility Help for more information.
  6. In the Database tab, click Connection to open the Select Data Source dialog box.
  7. Select the Machine Data Source tab and click New to open the Create New Data Source dialog box.
  8. Select System Data Source (Applies to this machine only) and then click Next.
  9. In the list of drivers, select SQL Server and then click Next.
  10. In the next dialog box, click Finish.
  11. In the Create a New Data Source to SQL Server wizard, enter a Name, Description, and the Server IP address for the new data source connection. Then click Next.
    The server IP address should be the new IP address of the machine on which the Email Log Database is located.
  12. In the next dialog box, select options as described below.
    1. Select an authentication method for connecting to the database:
      • With Windows NT authentication using the network login ID: to use a Windows trusted account.
      • With SQL Server authentication using a login ID and password entered by the user: to use a SQL Server account.
    2. Enable Connect to SQL Server to obtain default settings for the additional configuration options.
    3. Enter the Login ID and Password of the sa SQL Server account if you selected SQL Server authentication in Step a above).
    4. Click Next.
  13. In the next dialog box, enable Change the default database to and then select esglogdb76 from the drop-down menu. Then click Next.
  14. In the next dialog box, accept the default settings and click Finish.
  15. Click Test Data Source to test the connection. Upon test success, click OK.
  16. Click OK, then click OK once more.
  17. In the SQL Server Login dialog box, enter a Login ID (by default, sa) and Password. Then click OK.
    If you choose to Use Trusted Connection (i.e., Windows NT authentication), Login ID and Password are not necessary.
  18. In the Email Log Server Configuration utility, click Apply and then OK to the warning message about stopping and restarting Log Server.
  19. On the Connection tab, under Service Status, click Stop. This stops Email Log Server.
  20. Click the same button (it now is labeled Start).
    This starts Email Log Server. It is now configured to use the new database location.
  21. Click OK to close the Email Log Server Configuration utility.