Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unable to retrieve external data via Excel Services [Emergency]

Status
Not open for further replies.

hdv212

Programmer
Dec 16, 2008
6
IR
Hi

i want to display external data (exists in sql server database) from excel service and allow user to refresh data. i was succesful to do this when i open it by excel client, but when i try it in web access mode,the previous modification display and new values does not show,and when i click on Update > Refresh Selected Connection, the following error display :

Unable to retrieve external data for the following connections:

full Test t1

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.

in my trusted location i set all checkboxes (including allow external data -> trusted data connections and embedded and children trusted -> true).

also :

i installed all components (including sql server 2005) on the same machine

i have not active directory and domain (using workgroup)

i don't use SSO, hence, i use None or Windows Authentication for data connection authentication setting.

also i was run this commands :

stsadm -o set-ecssecurity -accessmodel delegation -ssp sspname

iisreset

but still i got the same error.

i was also reinstall sharepoint in another virtual machine with Active Directory and start all services as mydomain\administrator account.

also, i was configure SSO via this article : Plan external data connections for Excel Services, but still i got the same error.

also, i was run this commands :

stsadm -o set-ecssecurity -accessmodel delegation -ssp SharedServices1
stsadm -o execadmsvcjobs
iisreset

to change access model to delegation mode, but still i got the same error.

can anybody help me ? [It's very emergency]

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top