July 26, 2010 at 7:14 am
We have Analysis Services through SQL 2008 (not R2 yet) that we've exposed via Excel 2007/2010. I want to push this into Excel Services in SharePoint 2010, but run into connection issues when I try to open a Pivot filter. I get the message:
The data connection uses Windows Authentication and user credentials could not be delegated. The following connections failed to refresh.
Any idea what I can do to get around this and let users see this data?
Thanks!
July 30, 2010 at 6:01 am
Depends on your architecture... if it's distributed (as opposed to all on one box) most likely you have the "double-hop" issue and need to configure Kerberos to correctly delegate user credentials between the relevant machines (WFE/MOSS AppServer/SSAS Server ect).
If you run profiler on the SSAS database whilst refreshing the report in sharepoint/excel services, you will see the credentials being used to run the MDX query... then you will know if the user running the query is having their credentials correctly delegated. It seems from your post that this might be the issue...
Kind Regards, Will
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply