App Control: How to find out external SQL Database details

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

To find out the name of the external SQL Server and Database instance that is connected to the App Control Server

Environment

• App Control(formerly CB Protection) Server: All Supported Versions
• Microsoft SQL Server: All Supported Versions

Resolution

Using the example of server name=PARITY-BIT9-SQL and database=das, any of the below files can be used to confirm the server details:

• C:\Program Files (x86)\Bit9\Parity Console\WebUI\html\Dashboard\Web.config:

  <add name="ConnectionString" connectionString="Trusted_Connection=No; uid=DBService; pwd=&quot;xxx&quot;; server=PARITY-BIT9-SQL; database=das;" providerName="System.Data.SqlClient"/>

• C:\Program Files (x86)\Bit9\Parity Console\WebUI\include\DataObject.ini:

  database_das ="sqlsrv://DBService:xxx@PARITY-BIT9-SQL/das"

• C:\Program Files (x86)\Bit9\Parity Server\Reporter\ParityReporter.exe.Config:

  <add key="ConnectionString" value="Trusted_Connection=No; uid=DBService; pwd=&quot;xxx&quot;; server=PARITY-BIT9-SQL; database=das" />

• C:\Program Files (x86)\Bit9\Parity Server\Reporter\WSProxy.config:

  <add key="ConnectionString" value="Trusted_Connection=No; uid=DBService; pwd=&quot;xxx&quot;; server=PARITY-BIT9-SQL; database=das" />

• C:\Program Files (x86)\Bit9\Parity Server\shepherd.dsn:

  SERVER=PARITY-BIT9-SQL 
  DATABASE=das

• C:\Program Files (x86)\Bit9\Parity Server\WSProxy.config:

  <add key="ConnectionString" value="Trusted_Connection=No; uid=DBService; pwd=&quot;xxx&quot;; server=PARITY-BIT9-SQL; database=das" />