Just Published! Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

App Control: SQL Server Protocol warning on console System Health Page

App Control: SQL Server Protocol warning on console System Health Page

Environment

  • App Control Console: All Supported Versions
  • Microsoft SQL Server: All Supported Versions
  • App Control Server: One-tier Architecture

Symptoms

  • When the App Control Server is hosted on the same application server as the SQL Server (referred to as One-tier or Single Tier Architecture); the Console reports a System Health warning stating, "The Carbon Black App Control Server is using the wrong protocol to connect to SQL Server."
  • This message is found by going to the gear icon > System Health > Infrastructure Configuration > SQL Server Protocol.

Cause

The SQL Server Configuration has more than only Shared Memory enabled. According to the 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. Login to the application server as the Carbon Black Service Account.
  2. Open SQL Server Configuration Manager > SQL Server Network Configuration > Protocols.
  3. Disable both TCP/IP and Named Pipes, leaving only Shared Memory enabled.
  4. Restart the App Control Server & Reporter services to refresh the Health Indicators.

Additional Notes

If the Issue Persists:
  1. Install the SQL Server Native Client if it is not already installed.
    • It is available for download from the SQL Server Feature Pack page on microsoft.com.
  2. Using notepad, open the file: "C:\Program Files (x86)\Bit9\Parity Server\shepherd.dsn"
  3. Find the line that starts with DRIVER=
  4. Make sure that it states:
    DRIVER=SQL Server Native Client 11.0
  5. If changes were made, restart the App Control Server & Reporter services to refresh the health indicator.

Related Content


Labels (1)
Was this article helpful? Yes No
100% helpful (1/1)
Article Information
Author:
Creation Date:
‎03-26-2019
Views:
1388
Contributors