Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am reading a step-by-step book to learn more about SQL Server Analysis Services. I am creating a dimension for an AdventureWorks data source. In the Design Diagram pane, I right click on the header of a table and then I click 'Explore Data'. I am given this error: The 'SQLNCLI10.1' provider is not registered on the local machine.

From searching online it sounds like I have to find out how to change my provider to'SQLNCLI11', or 11.1, in some connection string, but I don’t know how to find this connection string.

I have SQL Server 2012, Visual Studio 2010 Shell(SQL Server Data Tools), and Visual Studio 2012.

share|improve this question
Install the SQL Server Native Client. Scroll down and find it Although native client 10 is SQL Server 2008 so you might need to get it from the 2008 feature pack page. I don't know if 2012's has all the previous versions in it. – Jul 5 '13 at 22:14
Thanks @ta.speotis, I just tried to install the 2012 native client and got this error: Installation of SQL Server 2012 Native Client failed because a higher version exists on the machine. If I am using SQL Server 2012 should I really install the 2008 client to work for client 10? Shouldn't I just update the solution to use client 11? How do I do that? – Kyle Weller Jul 5 '13 at 22:26

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.