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
- Log in to the application server where App Control Server is installed.
- If an Agent is installed, temporarily stop & unload the Agent.
- Stop the App Control Server & Reporter services.
- 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="<NEWPASSWORDHERE>";
- 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
- 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
- Start the App Control Server & Reporter services.
- If the Agent was stopped & unloaded (step 2), load & start it now.
Related Content