none
Provider 'Microsoft.SQLServerMPPOLEDBProvider' not installed on local machine - Power Pivot/PDW

    Question

  • Hello,

    This is my first post, so I apologize if I'm violating any etiquette or protocol here. I've scoured for answers to this question and found none, so this is my last resort.

    I'm using Office 365 Excel (64-bit). In my Excel Data Model, I have tried to connect to our SQL Server 2012 PDW by selecting 'Other Sources' and 'Microsoft SQL Server Parallel Data Warehouse'. After inputting the server and login information, the connection fails, citing that "The Microsoft.SQLServerMPPOLEDBProvider is not registered on the local machine."

    I can't find any information about this provider, and when I change the provider to any other value in the connection string, it fails as well.

    Does anyone have any ideas about where I might find this provider and why it wasn't registered in the first place?

    Thank you,

    Jess

    Friday, May 30, 2014 3:05 PM

Answers

All replies