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.
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).
Release : 2.9.1
Component : Microsoft SQL Server Analysis Services
To register the SQL Server Native Client with the ITAnalytics data source, follow this procedure:
Once the provider has been registered, the cube processing job should run without error.