App Control Server Is Using the Wrong Protocol To Connect to SQL Server

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

Steps to correct the failed Health Indicator for SQL Server Protocol with the message:

The Carbon Black App Control Server is not connecting to SQL Server using the Shared Memory protocol.

Environment

• App Control Server: All Supported Versions
• Microsoft SQL Server: All Supported Versions
• Single Tier Environment

Cause

The SQL Server Configuration has more than only Shared Memory enabled. According to the App Control SQL Server Configuration Guide:

In order to simplify configuration and ensure fast connectivity between the App Control server and SQL server, the App Control “Operating Environment Requirements” (OER) specifies that both products must be installed on the same machine.

When deploying the App Control in this manner, SQL Server should be configured to communicate with the App Control Server using shared memory rather than TCP/IP.

Resolution

ATTENTION: These steps should only be completed if SQL Server and App Control Server are installed on the same application server (Single Tier). If not using a Single Tier installation, review the steps for Not Using Shared Memory Triggered in Two Tier Environment.

1. Log in to the application server as the Carbon Black Service Account.
2. Stop the App Control Server and App Control Reporter services.
3. Open SQL Server Configuration Manager > SQL Server Network Configuration > Protocols.
4. Set the Protocols as follows:
   • Shared Memory: Enabled
   • Named Pipes: Disabled
   • TCP/IP: Disabled
   
5. Choose SQL Server Services from the left-hand pane.
6. Right click SQL Server > Restart to apply the changes.
7. Start the App Control Server and Reporter services.
8. Log in to the Console > settings > System Health > Infrastructure Configuration > SQL Server Protocol.
9. Click the refresh arrows in the corner of the right-hand pane to verify the Health Indicator has cleared.

Additional Information

• Health Indicator for Not Using Shared Memory Triggered in Two Tier Environment
• The SQL Server Configuration Guide can be found on TechDocs > Server Documentation > SQL Server Configuration Guide.
• If the issue persists, the following steps may need to be taken:
  1. Stop the App Control Server and Reporter services.
  2. Install the SQL Server Native Client.
  3. Open the file: "C:\Program Files (x86)\Bit9\Parity Server\shepherd.dsn" and verify the DRIVER= line matches:
  4. Find the DRIVER= line and verify it matches:

     DRIVER=SQL Server Native Client 11.0

  5. Restart the SQL Server service.
  6. Start the App Control Server and Reporter services.
  7. Refresh the Health Indicator for the SQL Server Protocol.
• If disabling TCP/IP causes Console issues in a Single Tier environment, App Control may need to be reinstalled with the local SQL option instead of using the FQDN of the SQL Server.