Testing the SQL Connection from Application to SQL Server
search cancel

Testing the SQL Connection from Application to SQL Server

book

Article ID: 286727

calendar_today

Updated On:

Products

Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

How to 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

  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.