Updating the log database location for Email Security Gateway

Deployment and Installation Center | Email Security Solutions | Version 7.7.x

Email Security Gateway and Email Security Gateway Anywhere, v7.7.x

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

Complete these steps even if the Email Security Log Database is located on the same machine as TRITON Unified Security Center or Email Security Log Server.

Log on to the TRITON Unified Security Center and click Email Security.

Go to Settings > Reporting > Log Database and enter the new IP address in the Log database field.

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

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

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

On the machine running Email Security Log Server, start the Log Server Configuration utility (Start > All Programs > Websense > Email Security > Email Security Log Server Configuration).

In the Database tab, click Connection to open the Select Data Source dialog box.

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 Security database.

Select System Data Source (Applies to this machine only) and then click Next.

In the list of drivers, select SQL Server and then click Next.

In the next dialog box, click Finish.

10.

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

11.

In the next dialog box, select options as described below.

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.

Enable Connect to SQL Server to obtain default settings for the additional configuration options.

Enter the Login ID and Password of the sa SQL Server account if you selected SQL Server authentication in Step a above).

Click Next.

12.

In the next dialog box, enable Change the default database to and then select esglogdb7x from the drop-down menu. Then click Next.

13.

In the next dialog box, accept the default settings and click Finish.

14.

Click Test Data Source to test the connection. Upon test success, click OK.

15.

Click OK, then click OK once more.

16.

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.

17.

In the Email Security Log Server Configuration utility, click Apply and then OK to the warning message about stopping and restarting Log Server.

18.

On the Connection tab, under Service Status, click Stop.

This stops Email Security Log Server.

19.

Click the same button (it now is labeled Start).

This starts Email Security Log Server. It is now configured to use the new Email Security database location.

20.

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