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.
Version 7.6:
 
To reset the 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 ODBC connection:
  1. Log on to the Log Server.
  2. Click Start Programs Administrative Tools Data Source (ODBC).
  3. Click the System DSN tab wslogdb70 Configure Next.
  4. Select With SQL Server Authentication using a login ID and password entered by the user.
  5. Type the Login ID and Password, and then click Next.
  6. Click Next and then click Finished.
  7. Click Test Data Source and then click OK three times.
To update the Log Server connection:
  1. Open the Websense\Web Security folder.
  2. Run the Web Security Log Server Configuration program.
  3. Click the Database tab and click the Connection button.
  4. Click the Machine Data Source tab, click wslogdb70, and then click OK.
  5. Type the Login ID and Password, and then click OK.
  6. Click Apply, click the Connection tab, and click the Stop button.
  7. Wait for 15 seconds and then click the Start button.
  8. Wait for another 15 seconds. If the service continues to run, click OK.

Article Feedback



Thank you for the feedback and comments.