Testing the SQL Connection from Application to SQL Server

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

Test the SQL Connection from the App Control Server to the SQL Server

Environment

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

Resolution

Via UDL file

1. Create the Data Link file:
   1. Open Notepad.exe (or any text editor)
   2. Leave the file blank, and click File > Save As
   3. Name the file AppControlDBTest.udl (any name is fine, but it needs to end with .udl)
   4. Double click to open the UDL file that was created
2. Test the connection
   1. Under the Provider select Microsoft OLE DB Driver for SQL Server and click Next
   2. For "Select or enter a server name" enter the server name and database instance. Ex:

      appcserver\sqlexpress

   3. Select the authentication type (Windows Authentication or SQL Server Authentication)
      • For Windows Authentication - Server SPN enter the FQDN of the Database server. Ex:

        appcontrol.lab.local

      • For SQL Server Authentication - Enter the Username and Password of the SQL Account
   4. For Select the Database, confirm DAS is available in the dropdown
   5. Click Test Connection

Via ODBC Data Sources

1. On the App Control server, login as the Carbon Black Service Account
2. Go to Start > Windows Administrative Tools > ODBC Data Sources
3. Go to System DSN > Add > SQL Server > Finish
4. Provide a Name for the connection and the SQL Server Name (and SQL Instance, if any: myserver\myinstance)
5. Verify the option, "Windows NT authentication" (which will use your Carbon Black Service Account) is checked
6. Verify the option, "Connect to SQL Server to obtain default settings" is checked
7. Accept all the defaults and click Next 'til you get to click Finish
8. Click Test Data Source

Additional Information

SQL Permissions Required For App Control