Solved

Cannot Connect To SharePoint PowerPivot Workbook

Posted on 2013-05-14
1
1,087 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

756 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