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

Products

• Control Compliance Suite Standards Server
• Control Compliance Suite

Issue/Introduction

Control Compliance Suite (CCS)

You have installed Microsoft OLE DB Driver 19 on a couple of servers but are still getting the error "Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is not installed." when we 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

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.