The OLE DB provider "SQLNCLI10.1" has not been registered.; 42000.
- by lankylad
I have a SQL Server 2008 Analysis Services Project. In the Data Source View I have a Named Query which references a single Data Source containing three tables. The Project processes successfully and the cube can be browsed.
I recently added a second Data Source to the Data Source View and linked a table to the original Named Query.
When I try to process the project, I get the message:
OLE DB error: OLE DB or ODBC error: The OLE DB provider "SQLNCLI10.1" has not been registered.; 42000.
The Connection String for both Data Sources uses SQLNCLI10.1