Excel services are unable to delegate user credentials

Asked By nielsmel 20 points N/A Posted on - 08/04/2011

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.

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.

• Status: Open
• Question Views: 4034
• Answer Count: 2
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Taniya

Go To Solution

Best Answer

Best Answer

Answered By Taniya 0 points N/A #97852

Excel services are unable to delegate user credentials

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

About Taniya

Questions
0

Answers
3

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/04/2011
• Question Category: MS Excel

Answered By Queen Noman 0 points N/A #196149

Excel services are unable to delegate user credentials

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

About Queen Noman

Questions
0

Answers
100

Best Answers
21

• Vote Up 0 Vote Down

• Posted on - 11/27/2013
• Question Category: MS Excel