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.