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 (Formerly CB Protection) Console: 7.2.1.x and Higher
  • Microsoft SQL Server: All Versions

Symptoms

System Health Page Infrastructure Configuration Tab > SQL Server Protocol, indicating "The CB Protection Server is using the wrong protocol to connect to SQL Server"

Cause

The SQL Server is not using the recommended Protocol for best performance, which is the 'Shared Memory' Protocol

Resolution

  1. Reconfigure the protocols:
    1. Open the SQL Server Configuration Manager.
    2. Go to the protocols for the SQL Server instance being used.
      • If the SQL Server instance is only being accessed for the App control Server confirm Shared Memory is Enabled and consider disabling Named Pipes or TCP/IP so only Shared Memory can be utilized.
      • If the instance is shared confirm Shared Memory is listed first and is enabled.
    3. Restart the App Control Server to refresh the health indicator
  2. If the issue is still present:
    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. Open the file shepherd.dsn in the directory c:\Program Files (x86)\Bit9\Parity Server\.
    3. Look at the line of the file that specifies the driver being used. (It starts with DRIVER=)
    4. Make sure that it reads DRIVER= SQL Server Native Client 11.0.
    5. Restart the App Control Server to refresh the health indicator

 

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