ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Cube processing failure: the provider 'SQLNCLI10' is not registered

book

Article ID: 240024

calendar_today

Updated On:

Products

IT Analytics

Issue/Introduction

While running one or more cube processing jobs in IT Analytics (ITA), the job(s) fail and return the following error message:

Cube processing error. Possible causes include insufficient permissions to read Cubes Data Sources, external connection timeout on the Analysis Server or remote connections on SQL databases. Error: Errors in the back-end database access module. The provider 'SQLNCLI10' is not registered. The following system error occurred: Class not registered Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'ITAnalytics', Name of 'ITAnalytics'.

The error message will also include a reference to the dimension being processed.

Updating the database or data source impersonation information does not resolve this error.

Cause

The Native OLE DB\SQL Server Native Client 11.0 is not registered with the data source (i.e., the reference in the SSAS ITAnalytics database pointing to the ITAnalytics database hosted in the SQL Server database engine).

Environment

Release : 2.9.1

Component : Microsoft SQL Server Analysis Services

Resolution

To register the SQL Server Native Client with the ITAnalytics data source, follow this procedure:

  1. Using SQL Server Management Studio (SSMS), connect to the Analysis Services server hosting the IT Analytics cubes
  2. In Object Explorer, navigate to Databases > ITAnalytics > Data Sources
  3. Right-click the ITAnalytics data source and select Properties
  4. In the Data Source Properties - ITAnalytics window, edit the Connection String
  5. In the Connection Manager window, select Native OLE DB\SQL Server Native Client 11.0 from the Provider drop-down menu
  6. Enter the hostname or IP address of the SQL Server instance hosting the ITAnalytics database
    Note: If the ITAnalytics database was installed on a named instance, provide the instance name with the hostname, separated by a backslash  (i.e., hostname\instance_name)
  7. Under Connect to a database, select the ITAnalytics database
  8. Click the Test Connection button to confirm the connection is functional
  9. Click the OK button to close the Connection Manager window
  10. Click the OK button to close the Data Source Properties - ITAnalytics window

Once the provider has been registered, the cube processing job should run without error.