Solved

Cannot Connect To SharePoint PowerPivot Workbook

Posted on 2013-05-14
1
1,055 Views
Last Modified: 2013-05-18
I am ready to give up. I have installed PowerPivot on SharePoint and can view PowerView and the PowerPivot (Through Excel Services) just fine. The machine is a single box with SQL Server 2012, Server 2012, and SharePoint 2013 all installed on it. Active Directory is also installed and configured.

When I try and download the .odc file to use the PowerPivot workbook as a datasource, I get an error after I click "enable" in Excel. THe error I keep getting is:

"Unable to connect to datasource. 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."


I never enter my credentials, and I am the administrator of this test machine. What do I need to do before I go out of my mind?
0
Comment
Question by:nirajkrishna
1 Comment
 
LVL 15

Accepted Solution

by:
colly92002 earned 500 total points
ID: 39167369
Microsoft have a KB about this here:
http://support.microsoft.com/kb/2712071

Also, have you set up yout stored credentials?  I'm not sure if this is relevant to your scenario but worth checking through:
http://msdn.microsoft.com/en-us/library/ee210671.aspx
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now