Excel services are unable to delegate user credentials

Asked By 20 points N/A Posted on -
qa-featured

Hi to all readers,

I have a problem here that I encountered while using Microsoft Excel, an error message appeared on my screen, the error message goes: The data connection uses Windows Authentication and Excel Services is unable to delegate user credentials. The following connection failed to refresh.

The data connection uses Windows Authentication and Excel Services is unable to delegate user credentials

Excel Web Access

The data connection uses Windows

Authentication and Excel Services is unable

to delegate user credentials. The following

connection failed to refresh:

Sandbox

Learn more about data refresh

                                                          OK

As I am analyzing the error message above, I have a hard time solving the issue. This is my first time to encounter such error message. I already searched the internet for some articles about this error, but I did not find anything similar to this.

Please make some comment on my problem. Thanks.

SHARE
Best Answer by Taniya
Best Answer
Best Answer
Answered By 0 points N/A #97852

Excel services are unable to delegate user credentials

qa-featured

Niel,

The issue can be caused when the Windows Token Service is not running. Please try the following steps to check the status of the Claims to Windows Token Service:

  • In Central Administration, click System Settings.
  • Now click Manage services on the server.
  • Select Claims for Windows Token Service, and click Start to Of the service.

Also verify that the service is running in the Services console. Follow the below steps to do so:

  • In Administrative Tools, click Services.
  • Start the Claims to Windows Token Service if it is not running.

If the above steps do not work, please contact your network administrator to verify the following:

  • The domain controller is available to validate the user identity.
  • The computer is the member of the same domain.
  • Use Windows domain user account.
  • The Excel Services service account must have Active Directory permissions to query the object.

Hope the information is helpful.

Cheers,

Taniya

Answered By 0 points N/A #196149

Excel services are unable to delegate user credentials

qa-featured

Hi.

There are multiple scenarios for that error. The most common is that Excel Services can`t find a valid Windows user identity. Follow this few steps to fix this:

1) In Central Administration, in System Settings, click Manage services on server.

2) Select Claims to Windows Token Service, and then click Start.

3) Verify the service is also running in the Services console:

4) In Administrative Tools, click Services.

5) Start the Claims to Windows Token Service if it is not running.



Queen Norman

Login/Register to Answer

Related Questions