Cube processing error: The provider 'MSOLEDBSQL' is not registered

Products

• Information Centric Analytics

Issue/Introduction

The nightly RiskFabric Processing job and the RiskFabric Intraday Processing job fail during cube processing and log the following error message:

<Error ErrorCode="3239116925" Description="Errors in the back-end database access module. The provider 'MSOLEDBSQL' is not registered." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3238068224" Description="The following system error occurred:  Class not registered " Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3239182436" Description="Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'RiskFabric', Name of 'RiskFabric'." Source="Microsoft Analysis Services" HelpFile="" />

Environment

Release : 6.x

Component : Microsoft SQL Server Analysis Services

Cause

Updates to SQL Server Management Studio (SSMS) may uninstall or corrupt the MSOLEDBSQL driver files.

Resolution

Download and install Microsoft's MSOLEDB 18 driver on the server hosting SQL Server Analysis Services:

Release notes for the Microsoft OLE DB Driver for SQL Server