Export (0) Print
Expand All

Add a trusted data provider

SharePoint 2007

Updated: March 26, 2009

Applies To: Office SharePoint Server 2007

Updated: 2009-03-26

In this article:

About trusted data providers

Trusted data providers are external databases that Excel Calculation Services is explicitly configured to trust when processing data connections in workbooks. Excel Calculation Services attempts to process a data connection only if the connection is to a trusted data provider.

You can control access to external data by explicitly defining the data providers that are trusted and recording them in the list of trusted data providers. The list of trusted data providers designates specific external data providers to which workbooks opened in Excel Calculation Services are permitted to connect.

Before instantiating a data provider to enable a workbook to connect to an external data source, Excel Calculation Services checks the connection information to determine whether the provider appears on the list of trusted data providers. If the provider is on the list, a connection is attempted; otherwise, the connection request is ignored.

Add a trusted data provider

Use the following procedure to add a trusted data provider.

Add a trusted data provider

  1. From Administrative Tools, open the SharePoint Central Administration Web application.

  2. On the Central Administration home page, click Application Management.

  3. On the Application Management page, in the Office SharePoint Server 2007 Shared Services section, click Create or Configure this Farm’s Shared Services.

  4. On the Manage this Farm’s Shared Services page, click SharedServices1 (Default). This is the Shared Services Provider (SSP) that you will configure.

  5. On the Shared Services home page, in the Excel Services Settings section, click Trusted data providers.

  6. On the Excel Services Trusted Data Providers page, click Add Trusted Data Provider.

  7. In the Provider ID section, type the identifier of the external database you want to add as a trusted data provider in Excel Services in Microsoft Office SharePoint Server 2007. Click OK.

    For information about how to perform this procedure using the Stsadm command-line tool, see Add-ecssafedataprovider: Stsadm operation (Office SharePoint Server).

Download this book

This topic is included in the following downloadable books for easier reading and printing:

See the full list of available books at Downloadable books for Office SharePoint Server 2007.

See Also

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft