I took the time to get in touch with excelservice last week. Today I am just free to write my notes to my blog.
This chapter describes how to solve the errors caused by refreshing the workbooks of external data sources.
1. Your workbook references external data sources (such as SQL, access, and other databases ).
{
To reference an external data source, you can first create a data link library for a website, and then publish the data to the database. After approval by the Administrator, the data source can be used only after approval. As for these steps, I have no specific operation steps due to time issues... You can search and view related documents online if you are not clear about them or if you are new to them...
}
Management Center shared service management-> excelservice Configuration:
2. choose "Shared Service Management"> "excelservice Settings"> "Configure trusted Files"> "external data"> "connect to a trusted Database" in the management center. (there are three options in total, the remaining two are "NONE", "trusted database and embedded link library". Generally, 2nd are selected, because in 2nd cases, even if the user uploads external data sources to the Data Connection Library of the site, as long as it is not approved by the Administrator, no one else can use it, which is conducive to the security of the moss server)
3. In the management center, choose Shared Service Management> excelservice Settings> trusted Data Connection database to add the path of your site data connection database.
After the configuration above, refresh your workbook may cause the following error message:
Data Connection Failed, unable to search external link data for the following, the data source is not reachable, no response or access is rejected (I did not, but can only use Article In the following section ....)
Solution:
Run a small command with stsadm
1 @ Set stsadm = " C: \ Program Files \ common files \ microsoft shared \ Web Server Extensions \ 12 \ bin \ stsadm.exe "
2 % Stsadm % - O Set - Ecssecurity - SSP sharedservices1 - Accessmodel Delegation
3 % Stsadm % - O execadmsvcjobs
4 Iisreset
5 Pause
Determine how Excel calculation Services handles authorization.
Trustedsubsystem is the default value in the Windows server farm.
Delegation is the default value for independent deployment or evaluation deployment.
For more information about the data access model, see the Excel services introduction, which may point to an English page? Linkid = 110227 & clcid = 0x804, which may point to the English page) in the "installation prerequisites and System Requirements" section.
For more information, see
Http://technet.microsoft.com/zh-cn/library/cc263284.aspx