View Complete Post
Hi to all,
I've an environment that includes 3 machines: the sp2010 frontend (W2K8 R2), the sp2010 backend (SQL2008 R2), the analysis services backend (SQL2008 R2).
I've successfully setup my environment with Kerberos constrained delegation and the entire thing works fine with both performancepoint and excel services (the requirement was to pass the user's domain identity to the analysis backend): thanks to the
excellent SP2010 Kerberos Guide.
Now I've extended this portal to the Extranet zone, assigned it a new host header and upgraded my SPNs to include the new fqdn and also added it to the necessary accounts in Active Directory.
In the intranet environment everything is fine. I've published the Sharepoint site to the external network onto the ISA 2006 and setup the Kerberos constrained delegation from the isa computer account to the Sharepoint SPN.
So here is the point: I can correctly access the Sharepoint site from external with Kerberos authentication, performancepoint is fine but I cannot open excel workbooks from this zone, I already trusted both the file and the data connection locations with
the external fqdn but still no luck. Even the sample workbook does not open. The error is "error while trying to execute the requested action. Retry".
Anyone has any hint on the possible causes?
In SharePoint 2010, Project Server 2010, Business Intelligence Center, upon attempting to refresh OLAP data in an Excel chart in the browser, the following error appears:
An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh:
My ODC Connection Name
We have loaded and configured Project Server 2010 according to spec (http://technet.microsoft.com/en-us/library/ee662109.aspx). Excel Services is configured according to spec (global
settings, trusted file locations, trusted data providers and trusted data connection libraries). The Secure Store Service is configured with the ProjectServerApplication target application.
Non-OLAP data refreshes of spreadsheet data work fine in the browser. OLAP data refreshes in the Excel client itself work fine. Only the OLAP refreshes in the browser fail. The problem occurs whether using a Microsoft ODC or one that
we created (saved in a trusted location).
The ULS log has only one error, which is:
06/21/2010 13:47:17.86 w3wp.exe (0x1238) &