Share via


Set-ecsexternaldata: Stsadm operation (Office SharePoint Server)

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: 2015-03-09

Operation name: Set-ecsexternaldata

Description

Lets an administrator configure an external data connection to Excel Calculation Services.

This operation is equivalent to the External Data user interface setting that is located on the Excel Services Settings page of the Shared Services Administration Web site.

For additional information about external data and Microsoft Excel Calculation Server, see Plan external data connections for Excel Services

Syntax

stsadm -o set-ecsexternaldata

**   –ssp <SSP name>**

**\[-ConnectionLifetime \<time in seconds\>\]**

**\[-UnattendedServiceAccountName \<account name\>\]**

**   -UnattendedServiceAccountPassword <account password>]**

Parameters

Parameter

Value

Required?

Description

ssp

A valid SSP name, such as "SharedServices1"

Yes

The name of the SSP that provides the resources for the Excel Calculation Services you want to configure.

connectionlifetime

One of the following values:

  • -1: Never recycle

  • 0 to 2073600 (24 days)

No

Maximum time, in seconds, for a connection to remain open. Older connections are closed and reopened (that is, "recycled") for the next query.

The default value is 1800 seconds.

unattendedserviceaccountname

A valid string value

No

Name for a default Windows account that Excel Calculation Services uses for connecting to data sources that require username and password strings for authentication.

The maximum character length is 4096.

unattendedserviceaccountpassword

A valid string value

No

Password for a default Windows account that Excel Calculation Services uses for connecting to data sources that require user name and password strings for authentication.

The maximum character length is 4096.