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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

"Use any authentication protocol" not allowed by CorpAudit for Excel Services

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

Hi there,

we have successfully installed SharePoint 2010. Our next goal is to use the Excel Services. The therein published sheets contain a data connection to an SSAS cube which again holds the corresponding user permissions in their roles. In order to pass the windows credentials on to the SSAS cube we need to translate the Claim back to a windows token. According to this whitepaper (a href="http://technet.microsoft.com/en-us/library/ff829837.aspx">http://technet.microsoft.com/en-us/library/ff829837.aspx) we need to set up the constrained delegation with the option "Use any authentication protocol". Unluckily this option is not permitted to be set by our internal CorpAudit settings.

Does anyone of you have a workaround on this topic or is the use of the delegation of credential not possible at all without this setting?



View Complete Post

More Related Resource Links

Excel Services: Develop A Calculation Engine For Your Apps


The Excel Services architecture lets users design their own algorithms and share workbooks on a server.

Vishwas Lele and Pyush Kumar

MSDN Magazine August 2007

Excel: Integrate Far-Flung Data into Your Spreadsheets with the Help of Web Services


Excel 2003 lets you dynamically integrate the data provided by different Web services. It also lets you take advantage of the latest capabilities in Office 2003 to customize list views, graphs, and charts, and to catalog bulk items online or offline. Find out how you can makle the most of the data returned from your Web services with the Office 2003 Web Services Toolkit API.

Alok Mehta

MSDN Magazine February 2005

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.

Sample: Business Connectivity Services Excel 2010 Add-In

Download a sample add-in that shows 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.

Interacting with the Excel Web Services API for SharePoint Server 2007

Get a quick start with the Excel Web Services API, which enables interaction with published Excel 2007 workbooks in SharePoint Server 2007 from a remote application. Learn considerations around session state, security, and performance.

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)

Generating Multiple Excel Sheet using Reporting Services 2005.

<p> Hi, I'm currently developing a program using ASP.NET 2.0 (C#) and i am using Reporting Services 2005. One of the report requirements is to export a data to an excel with multiple excel sheet. Is there other way to generate multiple excel sheet using the reporting services? if yes, i would like to ask a sample code... Thanks in advance, JP  </p> 

Excel Services in the 2010a Image -- Excel Servcice in General ( no success)

On the WebApp that hosts the Project service portion of the demo (finweb) has anyone gotten Excel Services to work ?  I get a bunch of internal errors when I attempt to use this service..  I am also having problems getting Excel Service to work (in general) -- are there any particular small animals that need to be sacrificed in order to get Excel Services to work? I'm using Kerberos on a single box ( been through the Kerberos whitePaper) -- On my development server, I am authenticating OK (Fiddler) but the page that is returned ends abruptly before the grid is created. It's not the browser because I can view the samples at WssDemo...   Suggestions -- I've done a couple of re-installs all the back to IIS -  All science is either physics or stamp collecting

Excel Services XLSX shows different results when accessed via Sharepoint UX vs REST

I have an Excel services report that connects to Project Server 2010 data via an ODC.  Looks great when I view the XLSX through the browser via the Sharepoint doc library; everything refreshes, no warnings, all is good.    But when I access this same file via the Excel Services REST call: https://myserver/_vti_bin/ExcelRest.aspx/ProjectBICenter/My%20Reports/Initiative%20Status%20Report.xlsx/model/PivotTables('InitiativeStatusSummary')?$format=html I get an older version of the report -- not refreshed with the latest data.   I have the file set to "refresh data when opening the file" in the data connectioon properties.     What am I missing?

Performace point/Excel services OLAP cubes

Running Sharepoint 2010 Ent fresh install.  I have created a new site and performance point service as instructed in the following tutorial. http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx I have then uploaded an Excel document which pulls data from OLAP cubes.  The Excel doc as a standalone works fine.  After it has been uploaded users can open it as normal etc but when changing slicers and trying to pull info from the cubes I get the following error.. An error occurred durning an attempt to establish a connection to the external data source.  The following connections failed to refresh: "Name of out cubes here" I have been playing with the secure store and generating keys etc to no avail.  I have tried exporting the .odc file from the Excel document and uploading it to the data connections library/dashboard site but this doesnt help The anoying thing is that I had it working once and then the next day it failed for no apparent reason and even after a fresh install I cant get it to work again.  Any pointers or tutorials would be greatly appreciated! Andy

Excel Services 2010 Error - "The workbook cannot be opened."

I enabled Excel Services and added a Excel Web Access viewer to my page. It's just a simple spreadsheet (which incidentally works fine on my standalone development server) that displays the error "The workbook cannot be opened." when the page loads. The trusted file locations are set up appropriately. We are using Kerberos authentication. My event viewer showed this "Critical" event (ID: 3760): SQL Database 'Prod_WSS_Content' on SQL Server instance 'servername' not found. Additional error information from SQL Server is included below. Cannot open database "Prod_WSS_Content" requested by the login. The login failed. Login failed for user 'domain\user'. In other words, the service account that ECS was running under did not have permission to the content database. So I granted the user read permission on the database. Then I got the same error and this "Error" level event in the event viewer (ID: 5617): There is a compatibility range mismatch between the Web server and database "Prod_WSS_Content", and connections to the data have been blocked to due to this incompatibility. This can happen when a content database has not been upgraded to be within the compatibility range of the Web server, or if the database has been upgraded to a higher level than the web server. The Web server and the database must be upgraded to

Target audiences not working in excel services web part

My appologies i posted this originally in the pre-2010 forum So i'm reposting here: We have recently upgraded to Sharepoint 2010 and we're experiencing problems with the "target audience" field being available to the users. I am not the CA admin though so it'll make this a bit tough to get solved if the problem is there. What i'm looking for are the suggestions of things for me to forward to the CA admin to change or check if anything. We have a seperate Virtual Machine that is running 2010 that has this option available to users on that farm for some reason. however on our corporate farm we don't have that option available. Plus on top of this the quick launch items are not working with audiences as well to turn off the headers to links that have nothing in them due to security trimming on document libraries. I'm hoping that this being a more of an overview of things to check would help others who may have this problem as well. I've seen resolutions such as rebooting the server and such, however that's a bit lower level and we need some higher level things to check that may resolve the issue. Think the simple stuff first to check and lets work down the list. Doesn't matter how stupid it is but can we get a more compiled list of things to check to make sure that target audience visibility to users is enabled? Thanks!

PerformancePoint Dashboard using Excel Services - How to export or print?

I have a PPS dashboard in 2010 that has an Excel services report with a nice graph and grid.  I do not see an "export to Excel" toolbar or a print function.  In the old 2007 Sharepoint, the Excel services report had a menu which allowed the user to export to excel (copy / paste) or OPEN in Excel.  (actually open the pivot table) How do I expose that menu bar in 2010?  Thanks.

An Excel Services Application setting does not allow the requested operation to be performed.

I'm facing a problem with Excel services and JSOM. On the page load, I'm registering a JSOM with a Visio webaccess webpart. On the shape selection changed event I'm trying to show a range of cells accordingly in the Excel web access webpart. Initially when the page is loaded and a shape selection event is fired, range.setValuesAsync(values); throws An Excel Services Application setting does not allow the requested operation to be performed. After pressing f5 on the page, it works fine. I came across a similar post in this link - http://social.technet.microsoft.com/forums/en-us/sharepoint2010programming/thread/B4739DB6-DDC1-42FB-BA6A-FFC41CBEFF1E but it was for Sharepoint 2010 beta 2 version. I'm having 14.0.4763.1000 - RTM build version. I have logged in as farm administrator. Log details Session=36.aceef71f-eb5b-4aab-9ce9-9db4728b45e5163.1.V22.91tY3PgMaeCbJtomFAb9Ab90.5.en-US5.en-US73.+0480#0000-11-00-01T02:00:00:0000#+0000#0000-03-00-02T02:00:00:0000#-006036.918121dd-d18e-4afe-b148-4cba08a0899b1.N b07378be-7293-4770-89cc-f136e1a8d7df WebServiceHelperMethods.ExecuteWebServiceRequestHandler: started processing 'SetRange' web method call b07378be-7293-4770-89cc-f136e1a8d7df WebServiceHelperMethods.ValidateContext: Operation requiring permissions 'SessionIdPresent, AllowEdits' not allowed according to the current permi
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