Support

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Working with Reports > Configuring Log Database options > Changing the Log Database
Changing the Log Database
Administrator Help | TRITON AP-EMAIL | Version 8.1.x
The Log Database may need to be changed when 1 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 2 locations: in the Settings > Reporting > Log Database page and in the Email Log Server Configuration wizard.
Use the following steps to change the Log Database configuration:
1.
Enter the IP address for the new Log Database in the Settings > Reporting > Log Database page, in the Log database field.
2.
Open the Email Log Server Configuration wizard for the Windows machine on which Log Server is installed (Start > All Programs > Websense > 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 Change the default database to drop-down list, 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.
Print print article Email email article Font Size: A A

Search

Article Rating:

Do you have any additional feedback?    Email: close

Quick Links

Service Requests

How are we doing?

Provide us feedback on your experience with the Service Request portal.

provide feedback >

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Working with Reports > Configuring Log Database options > Changing the Log Database