.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Sharepoint 2010 Excel Services Extranet Access

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :SharePoint
 

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?

Thanks in


View Complete Post


More Related Resource Links

Using the Excel Services REST API to Access Excel Data in SharePoint Server 2010 (Visual How To)

  
Learn how to use the REST API to retrieve resources such as ranges, charts, tables, and PivotTables from workbooks stored on SharePoint Server 2010.

Video: Using the Excel Services REST API to Access Excel Data in SharePoint Server 2010 (Visual How

  
Watch a short video that shows how to programatically retrieve data from an Excel workbook.

SharePoint 2010: Excel Services Resource Center

  
Are you looking to learn about Excel Services programmability capabilities? Learn about Excel Web Services, UDFs, the Excel Web Access Web Part, REST, and ECMAScript support.

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

  
Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Developing Applications in SharePoint 2010 Using Word Automation Services and Excel Services

  
Learn about the new client services features that are available in SharePoint Server 2010, including Word Automation Services and Excel Services.

Sample: Developing Applications in SharePoint 2010 Using Word Automation Services and Excel Services

  
Download sample code that demonstrates the new client services features that are available in SharePoint Server 2010, including Word Automation Services and Excel Services.

Video: Excel Services and SharePoint 2010 Business Intelligence

  
In this video you will learn how to create BI applications using Excel Services. (Length: 10:26)

SharePoint Server 2010 - no Excel Services?

  
hello   I've installed sharepoint server and wanted to configure Excel Services ...   and I cannot find any Excel Services in Central Administration portal there is information that services are installed but there is no such option in Administration portal   what went wrong ?   regards  

SharePoint 2010 and Access Services

  
I have published an Access Database to SharePoint and I get the following error "Your local machine time zone does not match your current SharePoint regional setting". I have checked region settings on the site and the web applicatin and all are set to Eastern TimeZone. Any ideas?

Direct Link to a Sharepoint 2010 file from Access, Excel, etc

  

Hi...our organization is upgrading to sharepoint 2010 from an earlier version.  In the earlier version, it was very easy to link to a document in a sharepoint library, from MS Access or Excel.  But now, on 2010 version, simply linking to the URL of the document no longer works.  It's like the file does not really exist in the location noted if you grab a shortcut URL.

Does anyone have any idea how we can continue to link to sharepoint 2010 documents, so all of our nicely linked access and excel processes continue to work

Hopefully I am making sense?

 

Pklocke


Excel Services installation in Sharepoint 2010

  

Hi,

I am using SharePoint 2010 Enterprise farm installation and want to publish an excel workbook to a sharepoint document library. On my SharePoint server, I currently do not have Excel Services installed as I am unable to create a new Excel Services service application (it does not show up in the New menu in Manage Service Applications inside Central Admin). Kindly let me know the procedure to correctly install Excel Services on my SharePoint Server.

Can anybody help me out ?


Sharepoint 2010 w/ Webapps, Excel Services Webpart display issue.

  

I have Sharepoint 2010 installed with WebApps 2010, and can use it to edit documents in IE without any problems at all.  Word and Excel work just fine.

But on MOSS 2007, I could have it display the Excel page as a webpart, that you can click on, and open it anyways.   But no matter what I try in 2010, all I get is the Webpart heading has a link to the file that works, but the contents always reads:

To display a workbook in this Web Part, you must first select the workbook.

To select a workbook, open the tool pane, and then edit the Workbook property.
Click here to open the tool pane.

 

How can I fix the preview in the webpart?

 

Thanks!

-Mark


Creating an Excel Services and Bing Maps Mashup for SharePoint 2010 (Visual How To)

  
Learn how to use a Bing Maps AJAX control to interact with an Excel Web Access Web Part using the Excel ServicesECMAScript object model.

Video: Creating an Excel Services and Bing Maps Mash-up for SharePoint 2010 (Visual How To)

  
Watch a short video as you learn to use Bing Maps AJAX controls to interact with Excel Web Access web parts.

Chapter 12: Excel Services (SharePoint 2010 Web App The Complete Reference)

  
Learn how to build Excel web-based applications in Microsoft SharePoint 2010 by using OpenXML.

New Content on Excel Services and Word Automation Services Development for SharePoint Server 2010 (B

  
Check out the new visual how-to videos and articles that showcase how to create interactive solutions around Excel Services in SharePoint 2010, as well as book excerpts for Excel Services and Word Automation Services.

Using the Calculation Power of Excel Using Excel Services in SharePoint Server 2010 (Visual How To)

  
Learn how to use Excel Web Services to harness the calculation power of Microsoft Excel programmatically.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend