search cancel

Required SQL OLE driver for agent based SQL data collection and TLS 1.2 in Control Compliance Suite 12.5

book

Article ID: 200461

calendar_today

Updated On:

Products

Control Compliance Suite Standards Server Control Compliance Suite Control Compliance Suite Windows Control Compliance Suite Databases MS SQL SRVR

Issue/Introduction

Control Compliance Suite (CCS)

To be able to perform an agent based data collection for SQL servers in a TLS 1.2 environment, the following MS OLE driver is required to be installed manually on each CCS 12.5 agent:

  • Microsoft OLE DB Driver 18 for SQL Server

Environment

Release : CCS 12.5/12.5.1

Component : SQL database collection in an TLS 1.2 environment.

Resolution

The following driver from Microsoft needs to be installed manually on each agent that is going to be performing SQL data collection.

  • Microsoft OLE DB Driver 18 for SQL Server

Download location for MS OLE DB Driver 18.5 (updated on March 4, 2021)

https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15