My 2p about ERP Solutions, Information Worker Solutions and other software products (mainly Microsoft Dynamics AX and Microsoft SharePoint).

13 October 2008

Data Refresh Failed

by Patrik Luca 6 comments

Tag



Problem Description: Data Refresh Failed


You have configured Microsoft Office SharePoint Server 2007 to enable workbooks load in Excel Services. You have stored your data connection in a trusted data connection library and your Excel 2007 workbook in a trusted file location. You open the Excel 2007 workbook and you apply a filter or you choose to Refresh All Connections. Following error message is appearing:
Unable to retrieve external data for the following connections:
Connection_Name
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.

Refreshing all connections or filtering with an administrator account works without problem.


Solution: Configure the Unattented Service Account


Go to SharePoint Central Administration and go to your Shared Service Provider. In the section Excel Services Settings, choose Edit Excel Services Settings. In the External Data section configure the Unattended Service Account: it should be an account with administrator rights. Execute an iisreset. Your problem should be fixed.

Comments 6 comments
J├╝rgen said...

Had the same issue- take a look at
http://msdn.microsoft.com/en-us/library/cc514223.aspx

used this cmdline statemant: stsadm -o set-ecssecurity -accessmodel delegation -ssp sspname

replace sspname with the name
restartet the IIS

Anonymous said...

Hi
I try to add user name password and tried its not working
Jenkins

Patrik Luca said...

Your user name is an account with administrator rights and you performed an iisreset yet?

Anonymous said...

i have the same problem

Anonymous said...

Try this. I've tried everything else out there until I came across this post. Fixed the issue immediately: http://ethan-deng.com/ExcelServicesIssue.aspx

Anonymous said...

http://ethan-deng.com/ExcelServicesIssue.aspx

not working

Patrik Luca, Ieper, BELGIUM
Feel free to use or spread all of the content on my blog. In return, linking back to my blog would be greatly appreciated. All my posts and articles are provided "AS IS" with no warranties.

Subscribe feeds via e-mail
Subscribe in your preferred RSS reader

Subscribe feeds rss Most Read Entries

Subscribe feeds rss Recent Entries

Categories

Recommended Books


Subscribe feeds rss Recent Comments

This Blog is part of the U Comment I Follow movement in blogosphere. Means the comment field of this blog is made DOFOLLOW. Spam wont be tolerated.

Live Traffic Feed

Recent Visitors

Blog Archive

My Blog List

Followers

Guest Links