Microsoft OLE DB Error when Importing SQL Agents and running CCS CER Jobs for Agent based collection

Products

• Control Compliance Suite Standards Server
• Control Compliance Suite

Issue/Introduction

Control Compliance Suite (CCS)

Microsoft OLE DB Driver 19 is installed on the server, but CCS is still reporting the error "Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is not installed." when you try to either Import or run a CER Job.  

Environment

CCS 12.6.x agent-based scans

Cause

Currently, CCS only supports the Microsoft OLE DB Driver 18 version.

CCS Software Requirements

Information from the CCS Technical Document URL above:

Prerequisites that are installed automatically

The CCS setup installs the following prerequisites automatically during the UI based installation:
You must install all these prerequisites manually if you are performing a silent installation of CCS components. CCS setup does not install any prerequisites automatically during the silent installation.
Microsoft .NET 4.7.2 framework
If you want to install it manually before CCS is installed, you can download it from the Microsoft website or use it from the Redist folder of the CCS installation package.
Microsoft Visual C++ 2015 redistributable framework
Microsoft installer 4.5
Microsoft OLE DB Driver 18 for SQL Server

Resolution

Please install the MS OLE DB Driver version 18.6.3 version on the Agent system.

https://docs.microsoft.com/en-us/sql/connect/oledb/release-notes-for-oledb-driver-for-sql-server?view=sql-server-ver15#previous-releases

Once this older version is installed, Asset Import jobs and Data Collection jobs will run.