Excel Services: Data Refresh Failed
After deploying an Excel file to Excel Services on a new MOSS Server I got the following error:
Data Refresh Failed: Unable to retrieve external data for the following connections:
<<connection>>
The data sources may be unreachable, may not be responding, or may have denied you access.
Verify that data refresh is enabled for the trusted file location and that the workbook data authentication is correctly set.
But the file was in an Excel Services Trusted Location and so was the data source.
Finally I found the following error message in the Sharepoint Log (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS):
Excel Services can not use credential delegation when it is configured to use a trusted subsystem with Windows SharePoint Server
Ok that explains it: when they installed Excel Services on this new machine they did not configure it to use Delegation Mode.
To change Excel Services to use Delegation Mode, you need to use the command line tool stsadm. Execute the following statements in a command window:
Cd C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN
stsadm -o set-ecssecurity -accessmodel delegation -ssp SharedServices1
stsadm -o execadmsvcjobs
iisreset
This should do it. Enjoy!
This will make the site use kerberos instead of NTLM
What Could be done for NTLM?
i need SERIOUS help. i’ve done all of this, i’m in a 3 server farm, it’s dev, so everything was configured using the same account, i know this account has correct permission. i’m using SSO, and the data will refresh just fine in the excel workbook, but i’m still getting this error in the excel services web part. i’ve tried all of this using two separate farms, and i’ve used two different sql servers in the domain for each farm to make sure it wasn’t a setting on the sql server. is there anything else that can be causing this issue (in my excel services settings, i’ve allowed data refresh, and i’ve allowed for all types of data connections (embedded et al). the report library is trusted as well as the data connection library. when i go into my logs, i see no excel services errors. HELP!!