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):
If the RiskFabric Intraday Processing job is enabled, this message will be logged for the following job steps:
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.
Version : All releases up to 6.6 MP2 (6.6.2.0)
Component : Microsoft SQL Server, Microsoft SQL Server Analysis Services
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.
Change the cube’s data source provider to Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) by following this procedure:
RiskFabric
OLAP cubeRiskFabric
relational databaseRiskFabric
database