"Cannot Connect to the Log Database" error message
- Article Number: 000001516
- Products: Forcepoint URL Filtering, Forcepoint Web Security, TRITON AP-WEB, Web Filter & Security, Web Security Gateway, Web Security Gateway Anywhere, Web Security and Web Filter
- Version: 8.5, 8.4, 8.3, 8.2, 8.1, 8.0, 7.8, 7.7, 7.6, 7.5
- Last Published Date: June 01, 2018
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"
In order to resolve the issue, follow the steps below.
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.
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