Article ID: 2712071 - View products that this article applies to.
Expand all | Collapse all

Symptoms

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.

Cause

This issue occurs when the request to authenticate the user account cannot be made through the PowerPivot redirector service: 
/_vti_bin/PowerPivot/Redirector.svc

Resolution

To resolve this issue, use one of the following methods, as appropriate for your situation:
  • The web application is set up to use the Kerberos authentication method. In this case, follow the steps in this MSDN article:
    Using PowerPivot Workbooks from a Mid-Tier Server Configured for Kerberos Authentication
  • The client that makes the call to the PowerPivot workbook does not have updated Microsoft Analysis services OLE DB drivers. Download the latest Analysis services drivers from following Microsoft Download Center website:
    http://www.microsoft.com/en-us/download/details.aspx?id=26728
  • The web application where the PowerPivot workbook is stored has multiple bindings in Internet Information Services (IIS). In this case, follow these steps:
    1. Open IIS, select the SharePoint web application, and then click Bindings.
    2. If more than one binding is listed, delete the additional bindings. 
  • The PowerPivot workbook is stored at the site collection level on the SharePoint server. In this case, the user account that makes the connection has to have access to the Root Web application.

Properties

Article ID: 2712071 - Last Review: December 3, 2012 - Revision: 1.0
Applies to
  • Microsoft SQL Server 2008 R2 PowerPivot for Microsoft Excel 2010
  • Excel Services in Microsoft SharePoint Server 2010
  • PerformancePoint Services in Microsoft SharePoint Server 2010
  • Microsoft Excel 2010
Keywords: 
kbprb kbkerberos kbpivottable kbexpertiseinter kbsurveynew KB2712071

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com