KB Article | Forcepoint Support

Notes & Warnings

This article assumes that the reporting databases already exist on your SQL Server. If the databases do not already exist or you want to create a new reporting database, review Running the database creation utility.

For version 7.6 and 8.4, the default directory for new installs is C:\Program Files\Websense\Web Security\ (32-bit machines) or C:\Program Files (x86)\Websense\Web Security\ (64-bit machines).

Problem Description

How do I update the Log Server and ODBC connections to the Log Database?



Updating the reporting database connection is required when either the Microsoft SQL Server account or the SQL account password changes.

If you are deploying a new SQL Server, Windows Trusted account, or simply changing the current password, or for Data if an alternative ODBC connection is required when creating a database table fingerprint or setting up database discovery, complete the following steps:

Update the ODBC connection:

Windows 32-bit Server:
  1. Click Start Control Panel Administrative Tools Data Sources (ODBC).
  2. Go to step 3 below.
Windows 64-bit or R2 server:

Important When running Log Server on a Windows 2008 64-bit or R2 machine, the 64-bit ODBC applet available under Administrative Tools or Control Panel is NOT used by Websense. Log Server uses the 32-bit ODBC application (odbcad32.exe) located in the %SystemDrive%\Windows\SysWOW64 directory. Updating the DSN connection from this location allows the Log Server Configuration utility to view the ODBC connection in the Machine Data Source tab.
  1. Navigate to the \%SystemDrive%\Windows\SysWOW64 directory.
  2. Right-click odbcad32.exe and click Run As Administrator.
  3. Click the System DSN tab.
  4. Select the System Data Source and then click Configure.
    1. If the reporting catalog database name is not displayed, then you must create a new Data Source entry.
    2. To create a new Data Source using the ODBC applet:
      1. On the System DSN tab, click Add.
      2. Select the SQL Server driver and then click Finish.
      3. Type a Data Source Name, type the SQL Server, and then click Next.
    3. To create a new Data Source from the Log Server Configuration utility:
      1. Click Start, click Programs, click Websense, click Utilities, and then click LogServer Setup.
      2. Click the Database tab.
      3. Click Connection.
      4. Click Machine Data Source tab and then click New.
      5. Click System Data Source and then click Next.
      6. Click SQL Server and then click Next.
      7. Click Finish.
      8. Type a Data Source name, click the SQL Server, and then click Next.
  5. Verify the Name and SQL Server entries are correct and then click Next.
  6. Select With SQL Server authentication using a login ID and password entered by the user, type the Login ID and Password and click Next.
  7. Click Change the Default Database, click the reporting catalog database, and then click Next.
  8. Select Change the Default Database to, select the catalog database in the drop down menu, and then click Next.
  9. Click Finish.
  10. Click Test Data Source.
  11. When the SQL Server ODBC Data Source test is complete you receive the message TEST COMPLETED SUCCESSFULLY, click OK.
  12. Click OK to close the test dialog box, and then click OK to exit ODBC Data Source Administrator applet.

For Web version 7.6

Update the Web Log Server connection :
  1. Click Start Programs Websense Web Security Web Security Log Server Configuration.
  2. Click the Database tab. The ODBC Data Source Name should display your reporting database name.
  3. Click Connection.
  4. Click the Machine Data Source tab and then double-click the Data Source Name.
    1. If there isn't a Data Source Name and you are running Log Server on a 64-bit machine, then you may not have opened the correct ODBC Data Source Administrator applet. You may need to execute odbcad32.exe from the \%SystemDrive%\Windows\SysWOW64 directory.
    2. If the correct Data Source Name is not listed, you may need to create a new one:
      1. Click New.
      2. In the Available Driver options drop-down, select SQL Server.
      3. Click Next.
      4. Click Finish.
      5. Type the Data Source Name, type the SQL Server, and then click Next.
  5. Type SA for the Login ID and type the password.
  6. Click OK.
  7. In the Log Server Configuration utility, click Apply.
  8. Click the Connection tab, click Stop, wait for the Server Status to display Service is Stopped and then click Start.
  9. If the Server Status continues to display Service is Running for more than 30 seconds, click OK to exit.
  10. On the TRITON Manager server, click Start Administrative Tools Services.
  11. Locate both Websense TRITON - Web Security and Websense Reporting Tools, right-click and click Restart.

For Web versions 7.7 to 8.5:

Update the Log Server connection:

Note The ODBC connection is automatically updated when the Log Server connection is updated.
  1. Open Forcepoint Security Manager.
  2. Click the Web tab and click Settings > Reporting > Log Server.
  3. Under Log Database connection, update the database name, SQL Server location and connection method for the SQL server if it has changed.
  4. Click Test Connection.
  5. Click OK, then click Save and Deploy.
  6. Log off of TRITON Manager.
  7. On the TRITON Manager server, click Start > Administrative Tools Services.
  8. Locate Websense TRITON - Web Security, right-click and click Restart.
If you continue to have issues, you may need to update the SQL Server settings for the TRITON Unified Security Center. This is applicable for v7.4 to v8.5.
  1. Click Start Programs > Websense Websense TRITON Setup.
  2. Click Modify next to TRITON Infrastructure.
  3. Click Next.
  4. On the SQL Server page, type the new SQL Server credentials.
  5. In the Authentication drop-down menu, select Windows Authentication or SQL Server Authentication.
Note The SQL Server credentials used by the TRITON Infrastucture services are not automatically pushed to console modules (Web Security, Data Security, Email Security) when they are modified after installation.
  1. Generate a Websense report to confirm that new data is appearing. Review Running detailed activity reports - Investigative Reports for additional information about running reports.

linked kba; sql; setup; install; odbc; cannot connect to log server; reporting; sa; windows trusted; security manager

Article Feedback

Thank you for the feedback and comments.