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
Best Answer
What is the connection string used to connect the Data source, it should on similar lines of: Provider=SQLNCLI10.1;Integrated Security="";Persist Security Info=False;User ID=sa;Initial Catalog=AdventureWorksDW;Data Source=MyServer;Initial File Name="";Server SPN=""
The SQLNCLI10.1 is for SQL 2008 and higher version, you may also check and download from SQL 2008 R2 feature pack and reinstall on the server. SO you can try edit the Data Source(s) for the database and switch from the SQLNCLI.1 provider to the SQLNCLI10.1 Native Client provider.