Upgrade or remove the Microsoft SQL Server 2012 Native Client

Products

• Information Centric Analytics

Issue/Introduction

Microsoft SQL Server 2012 Native Client is installed on the Information Centric Analytics (ICA) database (DB) server and Analysis Services (SSAS) server. Is it possible to delete or upgrade this client?

Environment

Version : All releases up to 6.6 MP2 (6.6.2.0)

Component : Microsoft SQL Server, Microsoft SQL Server Analysis Services

Resolution

Prior to ICA 6.7, the RiskFabric OLAP cube uses the SQLNCLI11 provider to query the RiskFabric relational database during processing. As documented in the knowledgebase article OLE DB provider missing from SQL Server Analysis Services 2022, removing this provider will cause the following RiskFabric Processing job steps to fail:

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

Removing this provider will also cause the following RiskFabric Intraday Processing job steps to fail:

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

In order to safely remove the SQLNCLI11 provider, first 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

Additional Information

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.