Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

App Control: How to Update the Password for the SQL Local User Account

App Control: How to Update the Password for the SQL Local User Account

Environment

  • App Control Server: All Supported Versions
  • Microsoft SQL Server: All Supported Versions

Objective

To update the SQL sa account details used for the App Control database.
 

Resolution

  1. Log in to the application server where App Control Server is installed.
  2. If an Agent is installed, temporarily stop & unload the Agent.
  3. Stop the App Control Server & Reporter services.
  4. Update the following configuration files with the new sa password:
Warning: Make sure the new password entered matches the existing syntax in the config files, for example: 
pwd=&quot;<NEWPASSWORDHERE>&quot;;
  • C:\Program Files (x86)\Bit9\Parity Console\API\Web.config
  • C:\Program Files (x86)\Bit9\Parity Console\WebUI\include\DataObject.ini
  • C:\Program Files (x86)\Bit9\Parity Console\WebUI\html\Dashboard\Web.config
  • C:\Program Files (x86)\Bit9\Parity Server\install.dsn
  • C:\Program Files (x86)\Bit9\Parity Server\shepherd.dsn
  • C:\Program Files (x86)\Bit9\Parity Server\WSProxy.config
  • C:\Program Files (x86)\Bit9\Parity Server\Reporter\WSProxy.config
  1. If using Connectors the following paths may also need to be updated:
  • C:\Program Files (x86)\Bit9\Integrations\CheckPoint\bin\bit9.dsn
  • C:\Program Files (x86)\Bit9\Integrations\FireEye\listener\Web.config
  1. Start the App Control Server & Reporter services.
  2. If the Agent was stopped & unloaded (step 2), load & start it now.

Related Content


Labels (1)
Tags (2)
Was this article helpful? Yes No
50% helpful (1/2)
Article Information
Author:
Creation Date:
‎09-09-2020
Views:
1466
Contributors