Refresh PowerPivot data failed on the SQL Server Denali machine
I recently encountered an issue. When I try to refresh data for a PowerPivot Excel Spreadsheet on the SQL Server "Denali" machine, I got the 'SQLNCLI10' provider is not registered on the local machine error as below:
Failed to connect to the server. Reason 'SQLNCLI10' provider is not registered on the local machine.
Read more...