KB Article | Forcepoint Support

Problem Description

The following error message can be seen in multiple places such as Presentation Reports, Investigative Reports, and the Settings > Reporting > Log Database page. In addition, graphs on the Dashboard are not showing data.
 
"Cannot Connect to the Log Database"
 

Resolution

In order to resolve the issue, follow the steps below.

Solution 1:
If running the Websense Log Server with a Trusted Authentication to connect to the SQL Server, then some other Forcepoint services also need to use the same trusted account to pull the data from SQL Server.
  1. Click Start > Administrative Tools > Services, and verify what account the Websense Log Server service is configured with.
  2. Set the Websense TRITON - Web Security and Websense Web Reporting Tools services to run as the same account.
  3. Once configured, restart the services above.
  4. Also, ensure that the account being used has logon rights for the following services:
    • Websense TRITON - Web Security
    • Websense Web Reporting Tools
    • Websense Log Server
    • Websense TRITON - Web Server
  5. Log back on to the Forcepoint Security Manager to test the places where the error message was seen.
Note This action may not be necessary if the Log Server connection uses a SQL account with system administration rights rather than a trusted account.

Solution 2: 
Change the ODBC authentication method to use a SQL Server account (like the default sa account, or a custom account with appropriate permissions), rather than a Windows Trusted account. Refer to the articles below for more information on this process.
 


Note By default Microsoft SQL Server does not record logons to the Event Viewer so if there is a credential problem this will not be seen.

To change this behavior for SQL Server 2008 or 2005
  1. Open SQL Management Studio.
  2. Right-click on the SQL server name, and select Properties.
  3. Click Security and, under Logon auditing select the option for Failed logins only, then click OK.
After making this change, if an attempted SQL Server login fails, you will see a Failure Audit in the Event Viewer (under Applications). This can be helpful when troubleshooting connection problems.
 

Article Feedback



Thank you for the feedback and comments.