App Control: SQL Server Protocol Warning on Console System Health Page

[#1]

Environment

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

Symptoms

• App Control Server and SQL Server are installed on the same application server (Single Tier Architecture).
• Warning displayed in the Console > gear icon > System Health > Infrastructure Configuration > SQL Server Protocol:

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

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

1. Log in to the application server as the Carbon Black Service Account.
2. Stop the App Control Server and 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 > gear icon > System Health > Infrastructure Configuration > SQL Server Protocol > click the refresh arrows in the corner of the right-hand pane.

Additional Notes

• The SQL Server Configuration Guide can be found on VMware Docs > 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.
• As an example, the SQL Server Network Configuration should look similar to this:

This is a article attached image

Related Content

Carbon Black App Control Documentation