Excelservices-solves the error caused by refreshing the workbook of the external data source.

Source: Internet
Author: User
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.