Finding the SQL Server Instance Name the App Control Connects to

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

How can I tell what SQL server instance my server is connected to?

Environment

• App Control: All Supported Versions

Resolution

You can find this information following in 2 ways:

Web console:

1. Open the web console
2. Navigate to the System Configuration page > General tab > the database address is displayed e.g.

Database Address: SQL01\MSSQLSERVER

Locally on the server:

1. Log into your App Control server system
2. Browse to C:\Program Files (x86)\Bit9\Parity Server\ and then look for a file called "shepherd.dsn".
3. You can open this file using wordpad, notepad, etc.
4. You should then see an entry similar to the one below:

[ODBC]
DRIVER=SQL Server Native Client 11.0
UID=bit9
Trusted_Connection=Yes
DATABASE=das
SERVER=<YourSQLServerNameHere>

 

Additional Information

An example with a custom port can be found here