Add a trusted data provider

Applies To: Office SharePoint Server 2007

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.


Topic Last Modified: 2016-11-14

In this article:

  • About trusted data providers

  • Add a trusted data provider

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


Add a trusted data connection library