This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

can't refresh datas or filter data in Excel services: security error

Question
0

Sign in to vote
Hi,

I'm receiving this error:
The data connection uses Windows Authentication and Excel Services is unable to delegate user credentials.

when I try to refresh the data in an Excel services or if I try to filter the data on the screen (like selecting a value in a slicer)

For sure the folder is in the trusted sources of the Excel Services Application.

any idea?
- Moved by Mike Walsh FIN Friday, November 27, 2009 7:05 PM admin q (until there is a forum that covers Excel Services in SPS 2010) (From:SharePoint 2010 - General Questions and Answers)
Friday, November 27, 2009 6:53 PM

All replies

0

Sign in to vote

Moving to 2010 Admin.

There's also no mention of SharePoint 2010 in your post or Title so as MOSS 2007 has Excel Services too, please confirm that you are specifically asking about SPS 2010.

(and in future please always say so)

(Moderator)
FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com
Complete Book Lists (incl. foreign language) on each site.

Friday, November 27, 2009 7:05 PM
0

Sign in to vote

sorry for this...
for sure its Sharepoint 2010.

Friday, November 27, 2009 7:44 PM
0

Sign in to vote

I would like to the answer to this too!
There is just no way I can refresh any SSAS data in a browser worksheet.
Ofer

Friday, December 11, 2009 5:44 PM
0

Sign in to vote

I'd like the answer as well. The first thing I used to do when I got this error was to make sure Excel was configured for delegation (stsadm -o set-ecssecurity -accessmodel delegate) but I don't know how to do that using PowerShell in SP2010.

Monday, December 28, 2009 7:47 PM
0

Sign in to vote

Any luck with this anyone? I found the powershell command help but it does not work

Set-SPExcelServiceApplication -AccessModel "My Excel Services Application" Delegation

The help says that I can set the access model using "AccessModel" but I get an error -

Set-SPExcelServiceApplication : A parameter cannot be found that matches parame
ter name 'AccessModel'.
At line:1 char:43
+ Set-SPExcelServiceApplication -AccessModel <<<<
    + CategoryInfo          : InvalidArgument: (:) [Set-SPExcelServiceApplicat
   ion], ParameterBindingException
    + FullyQualifiedErrorId : NamedParameterNotFound,Microsoft.Office.Excel.Se
   rver.Cmdlet.SetSPExcelServiceApplication

Thanks

Tuesday, February 16, 2010 4:03 AM
0

Sign in to vote
verify that the "Microsoft "Geneva" Claims To Windows Token Service " is started... :)
- Proposed as answer by Roman Yusfin Thursday, June 28, 2012 1:56 AM
Tuesday, February 16, 2010 1:31 PM
0

Sign in to vote

Took me a while too to figure out that only Geneva will save the day :-)
If only MS would make it a bit LESS abvious :-)
Ofer Gal

Tuesday, February 16, 2010 6:44 PM
0

Sign in to vote

Thanks guys, I will try this tonight. Is it enough if the service is up and running or should I still run the Command to setup Delegation after starting the service?

Thanks in advance

Tuesday, February 16, 2010 9:29 PM
0

Sign in to vote

Hmm you get another error than i get, but it's still concerning Excel Services OLAP refresh - http://social.msdn.microsoft.com/Forums/en-SG/sharepoint2010setup/thread/3e530c08-9e6c-47dc-b937-25dc75b9cf1c

Hoping for an answer :-)

Wednesday, February 17, 2010 4:19 PM
0

Sign in to vote

I am afraid starting the "Microsoft Geneva Claims To Windows Token Service" did not help me. When I refresh the Data connections on the excel sheet from SPS, I still get the following error -

The Data connection uses Windows authentication and Excel services is unable to delegate user credentials. The following connections failed to refresh:

Any ideas?

Thanks

Thursday, February 18, 2010 2:18 AM
0

Sign in to vote

also do these steps:
http://msdn.microsoft.com/en-us/library/ee210616(SQL.105).aspx#Geneva

(and follows all the steps described in the article)

Thursday, February 18, 2010 2:23 AM
0

Sign in to vote
Do I need to do these settings? I am using Excel 2007, I was not sure if I need these as I am not using Excel 2010 and the PowerPivot Add-In? I am just trying to connect to the OLAP datasource using Data->From Other Sources->From Analysis Services and have a pivot table with cube data.

Thanks
- Proposed as answer by algkep Wednesday, March 3, 2010 11:16 PM
Friday, February 19, 2010 3:31 AM
0

Sign in to vote

Basically you need to verify if the Claim to windows Token Service is activated or not.

If not, please go to Central Administrator ->System Settings -> Manage Services on Server ->Claims to Windows Token Services ( Start this service )

Also verify if Administrative Tools ->Services ->Claims to windows Token Service is started.

Please go through the link http://msdn.microsoft.com/en-us/library/ff487975.aspx for more details

Thanks

Thursday, June 9, 2011 7:12 AM
0

Sign in to vote
Step 1:

Central Administration

step 2:

Manage services on server

and then

Claims to Windows Token Service Started Stop

just start the serive and you will be saying thanks to me :)

rizwan.shah@hotmail.co.uk
- Proposed as answer by Rizwan.genius Monday, April 16, 2012 5:23 PM
Monday, April 16, 2012 5:16 PM