Finding the SQL Server Instance Name

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

How can I tell what SQL server instance is?

Environment

• App Control: All Supported Versions

Resolution

If the App Control Server is already installed:

Option 1 - Via App Control console:

1. Log into the App Control console
2. Navigate to the System Configuration page > General tab > the database address is displayed e.g.

Database Address: AppCServer\SQLEXPRESS

Option 2- via shepherd.dsn file:

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>

If the App Control Server is not installed

Option 1 - Via SQL Server Management Studio (SSMS)

The name and instance are shown in the top left Object Explorer

Option 2 - Via SQL Server Configuration Manager (SSMS)

All instance names are shown in parenthesis under SQL Server Services

 

Additional Information

An example with a custom port can be found here