Article ID: 2712071 - View products that this article applies to.
In Microsoft Excel 2010, when you try to connect to a PowerPivot workbook as a data source on a Microsoft SharePoint Server 2010 share, you receive the following error:
Unable to connect to data source.
Reason: Access denied. You either made a mistake typing in your User ID and/or Password, or you do not have permission to access the database server.
This issue occurs when the request to authenticate the user account cannot be made through the PowerPivot redirector service:
To resolve this issue, use one of the following methods, as appropriate for your situation:
Article ID: 2712071 - Last Review: December 3, 2012 - Revision: 1.0