OLE DB provider missing from SQL Server Analysis Services 2022
search cancel

OLE DB provider missing from SQL Server Analysis Services 2022

book

Article ID: 279220

calendar_today

Updated On: 06-02-2025

Products

Information Centric Analytics

Issue/Introduction

After installing Information Centric Analytics (ICA) in an environment running Microsoft SQL Server 2022 (Enterprise Edition or Developer Edition), the following error message is logged while running the nightly RiskFabric Processing and the RiskFabric Intraday Processing jobs:

The OLE DB provider "SQLNCLI11" has not been registered. (Microsoft SQL Server, Error: 7403)

This message will be logged for the following RiskFabric Processing job steps (step ID noted parenthetically):

  • Risk Fabric cube processing (16)
  • Process Collections and Scenarios and Risk Models Measures Groups (18)
  • Process Risk Vectors Measure Group (20)

If the RiskFabric Intraday Processing job is enabled, this message will be logged for the following job steps:

  • Process DIM Measures and Dimensions (13)
  • Process Event Scenario Measures and Dimensions (15)

This message refers to the provider used by Microsoft SQL Server Analysis Services (SSAS) to connect to the RiskFabric relational database hosted by Microsoft SQL Server (MSSQL) during cube processing. If you attempt to edit the data source provider using SQL Server Management Studio (SSMS), the following error is displayed:

Connection Manager

The specified provider is not supported. Please choose different provider in connection manager.

Environment

Version : All releases up to 6.6 MP2 (6.6.2.0)

Component : Microsoft SQL Server, Microsoft SQL Server Analysis Services

Cause

From the Microsoft document SQL Server Native Client:

SQL Server Native Client (SNAC) isn't shipped with:

  • SQL Server 2022 (16.x) and later versions
  • SQL Server Management Studio 19 and later versions

The SQL Server Native Client (SQLNCLI or SQLNCLI11) and the legacy Microsoft OLE DB Provider for SQL Server (SQLOLEDB) aren't recommended for new application development.

For new projects, use one of the following drivers:

  • Microsoft ODBC Driver for SQL Server
  • Microsoft OLE DB Driver for SQL Server

For SQLNCLI that ships as a component of SQL Server Database Engine (versions 2012 through 2019), see this Support Lifecycle exception.

Resolution

Change the cube’s data source provider to Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) by following this procedure:

  1. Open SQL Server Management Studio (SSMS)
  2. Connect to the Analysis Services server hosting the RiskFabric OLAP cube
  3. In Object Explorer, navigate to Databases > RiskFabric > Data Sources
  4. Right-click the RiskFabric data source and select Properties
    The Data Source Properties - RiskFabric window opens
  5. Under the General heading, select the Connection String and click the ellipsis to the right of the string
    The Connection Manager window opens
  6. From the Provider dropdown menu, select Microsoft OLE DB Driver for SQL Server
  7. From the Server name dropdown menu, select the name of the server hosting SQL Server and the RiskFabric relational database
  8. From the Select or enter a database name dropdown menu under the Connect to a database heading, select the RiskFabric database
  9. Click the OK button to save your settings and close the Connection Manager window
  10. Click the OK button to save your settings and close the Data Source Properties - RiskFabric window