martedì 3 aprile 2012 23:17
I uploaded my "CORE" excel workbook in sharepoint--Powerpivot gallery, which it talks to busienss DB via SQL account.
Then I login the sharepoint and tried to create a thin workbook in sharepoint--Powerpivot gallery by cliking "Open new excel workbook" based on the "CORE"(the top-right corner button), unfortuanately, it reports the error like "Unable to connect to data source. Reason: access denied. You either make a mistake typing in your USERID and/or Password, or you do not have permission to access the database server."
My windows account has the full conrol of this sharepoint site. And this windows account has the read permission of sharepoint content DB and suffient permission to access the SQL2012 SSAS powerpivot mode.
Besides, if I open the "CORE" excel workbook, it works perfectly by creating the pivot chart/table.
Version: SQL2012 Powerpivot 11.0.2100.60
Does anyone know how to fix this?
Tutte le risposte
mercoledì 4 aprile 2012 00:23
on how to do this.
Unloved Excel FMVP
mercoledì 4 aprile 2012 00:30
Read it weeks ago. It still does not work
lunedì 16 aprile 2012 09:03Moderatore
Have you Configure Stored Credentials for PowerPivot Data Refresh, please refer to this link about this topic http://msdn.microsoft.com/en-us/library/ee210671.aspx
TechNet Community Support
- Contrassegnato come risposta Challen FuModerator lunedì 30 aprile 2012 09:13
mercoledì 19 settembre 2012 00:56
I'm seeing this same problem. When I select the "Open New Excel Workbook" for an existing "CORE" workbook, I see a dialog asking if I want to open or save the ODC file. I select "open" and then excel opens and gives me a warning about "Data connections have been blocked". I select "Enable" and then get the following message.
"Unable to connec to this 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."
The Stored Credentials are created and the "CORE" workbook auto refreshes on a schedule with no problems.
Any ideas on what else to check?
SharePoint 2010 SP1 (CU Feb-Mar) / PowerPivot 2012 (SQL Server 2012 CU2)