Export (0) Print
Expand All

Set-ecsexternaldata: Stsadm operation (Office SharePoint Server)

Office 2007

Updated: February 14, 2008

Applies To: Office SharePoint Server 2007

 

Topic Last Modified: 2008-02-01

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

stsadm -o set-ecsexternaldata

   –ssp <SSP name>

   [-ConnectionLifetime <time in seconds>]

   [-UnattendedServiceAccountName <account name>]

   -UnattendedServiceAccountPassword <account password>]

 

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.

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