KB Article | Forcepoint Support

Problem Description

How do I change the SQL Server password used by the Log Server?
 

Resolution

The account and passwords on the SQL Server, the ODBC, and the Log Server connections must all match. You will need to reset the SQL Server first.
 
For more information on updating the ODBC connection, review How to update the ODBC and the Log Server connections.
 
Versions 7.7 – 8.5:
 
Note The ODBC connection should update automatically after changing the Log Server connection through the Forcepoint Security Manager.
 
To reset the SQL password:
  1. Open Microsoft SQL Server Management Studio.
  2. In the Explorer pane, click Security > Logins > [ACCOUNT NAME].
  3. Right-click the specific account and click Properties.
  4. Click the General tab, type the new password, and then click OK.
To update the Log Server connection:
  1. Log on to the Forcepoint Security Manager.
  2. Click the Web tab.
  3. Click Settings > Reporting Log Server.
  4. Under the SQL Server authentication section, type the new password and click Test Connection.
  5. When the connection succeeds, click OK and then click Save and Deploy.
  6. Use the Windows Services dialog box to restart the Websense TRITON - Web Security service:
    1. Click Start and open the Run command.
    2. Type services.msc and press Enter.
    3. Locate the Websense TRITON - Web Security service.
    4. Right-click it and select Restart.



keywords: password; update; change; sql; odbc; reporting; logging; logs; log database

Article Feedback



Thank you for the feedback and comments.