Updating the Log Database location for Forcepoint Email Security

Before you begin

Note:

Applies to:

  • Forcepoint Email Security, v8.5.x

If the IP address of the Email Log Database machine (the IP address of the SQL Server machine) has changed, update the Forcepoint Security Manager and Email Log Server to use the new address.

Complete these steps even if the Email Log Database is located on the same machine as the Forcepoint Security Manager or Email Log Server.

Steps

  1. Log on to the Forcepoint Security Manager.
  2. Go to the Email > Settings > Reporting > Log Database page.
  3. Enter the new IP address in the Log database field.

    If the Email Log Database is located on the management server itself and you are performing this procedure because you changed the IP address of the management server, enter its new IP address here.

  4. Click OK (in the Log Database Location area of the screen).

    Leave the Security Manager at this screen.You will come back to it later to complete this procedure.

  5. On the machine running Email Log Server, start the Log Server Configuration utility (Start > All Programs > Websense > Email Log Server Configuration).
  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.

    You will create a new data source connection to the new IP address of the Email Log Database.

  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 database is located. If the database is located on the management server and you are performing this procedure because you have changed the management server’s IP address, enter its new IP address here.

  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. If SQL Server authentication was selected in step a, enter the Login ID and Password of the sa account.
    4. Click Next.
  13. In the next dialog box, enable Change the default database to and then select esglogdb7x 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 Email Log Database location.

  21. Click OK to close the Email Log Server Configuration utility.