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

  • Would like to hear if there was any resolution. I have the identical scenario. – Jeff Sacksteder Mar 21 '12 at 15:24

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.