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:
|
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. |