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
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