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

  • Question

  • 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

  • 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)

    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
  • sorry for this...
    for sure its Sharepoint 2010.
    Friday, November 27, 2009 7:44 PM
  • I would like to the answer to this too!
    There is just no way I can refresh any SSAS data in a browser worksheet.
    Friday, December 11, 2009 5:44 PM
  • 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
  • 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

    Tuesday, February 16, 2010 4:03 AM
  • 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
  • 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
  • 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
  • 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
  • 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?

    Thursday, February 18, 2010 2:18 AM
  • also do these steps:

    (and follows all the steps described in the article)
    Thursday, February 18, 2010 2:23 AM
  • 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.

    • Proposed as answer by algkep Wednesday, March 3, 2010 11:16 PM
    Friday, February 19, 2010 3:31 AM
  • 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


    Thursday, June 9, 2011 7:12 AM
  • 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 :)


    • Proposed as answer by Rizwan.genius Monday, April 16, 2012 5:23 PM
    Monday, April 16, 2012 5:16 PM