Cannot Connect To SharePoint PowerPivot Workbook

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?
nirajkrishnaAsked:
Who is Participating?
 
colly92002Connect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.