App Control: SQL Server Protocol warning on console System Health Page
App Control Console: All Supported Versions
Microsoft SQL Server: All Supported Versions
App Control Server: One-tier Architecture
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.
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.
Login to the application server as the Carbon Black Service Account.
Open SQL Server Configuration Manager > SQL Server Network Configuration > Protocols.
Disable both TCP/IP and Named Pipes, leaving only Shared Memory enabled.
Restart the App Control Server & Reporter services to refresh the Health Indicators.
If the Issue Persists:
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.
Using notepad, open the file: "C:\Program Files (x86)\Bit9\Parity Server\shepherd.dsn"
Find the line that starts with DRIVER=
Make sure that it states:
DRIVER=SQL Server Native Client 11.0
If changes were made, restart the App Control Server & Reporter services to refresh the health indicator.