Required MS SQL drivers needed for Agent-based SQL data collection in Control Compliance Suite 12.5.x

book

Article ID: 209481

calendar_today

Updated On:

Products

Control Compliance Suite Standards Server Control Compliance Suite Control Compliance Suite Windows Control Compliance Suite Standards Database

Issue/Introduction

Control Compliance Suite (CCS)

When installing the MSSQL CCS Snap-in on servers that you would like CCS to scan the MSSQL databases, the Microsoft SQL client is no longer installed automatically with the CCS SQL Snap-in.  The MSSQL client now has to be installed manually on each agent to collect SQL data. 

Cause

The Microsoft SQL client would sometimes force a reboot of the server, and that is not something that Symantec can control or change.  Because of this feature from Microsoft, Symantec has removed the MSSQL client from our install and it now has to be manually installed on each server before CCS will be able to collect SQL data.

Environment

Release : 12.5, 12.5.x

Component :  CCS Agent with the SQL Snap-in required for data collection of MS SQL assets

Resolution

For data collection of MS SQL databases on a server with a CCS agent, the MSSQL client needs to be installed on each agent so CCS can collect data. 

From SCU 2019-2 onwards, for agent-based data collection you must manually install specific drivers depending on the version of operating system of the agent computer and corresponding versions of MS SQL Server. 

For SCU 2019-2 to 2020-1 for MS SQL 2008(R2):

  • Microsoft SQL Server 2012 Native Client -version 11.0.7001.0 (Deprecated by Microsoft, no longer supported by Symantec)

NOTE: SQL 2008 (R2) has been deprecated by Microsoft as of January 2021, and is no longer supported by Symantec as of CU 2021-1

 

For SCU 2020-1 onward:

For all other supported MSSQL databases:

 

Currently supported platforms and databases:

https://techdocs.broadcom.com/us/en/symantec-security-software/information-security/control-compliance-suite/12-x/ccs-support-matrix-v123000389-d8e133191.html

 

 

Additional Information

Information on the new release of OLE DB Driver for SQL Server from Microsoft:

https://docs.microsoft.com/en-us/archive/blogs/sqlnativeclient/announcing-the-new-release-of-ole-db-driver-for-sql-server