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

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

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

Environment

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

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

4. 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

5. Start the App Control Server & Reporter services.
6. If the Agent was stopped & unloaded (step 2), load & start it now.