Data Retrieval Services: Stsadm properties (Windows SharePoint Services)
Applies To: Windows SharePoint Services 3.0
Topic Last Modified: 2007-09-07
A data retrieval service implements a data-binding technology that enables data consumers and data sources to communicate with each other through SOAP and XML. Data retrieval services are XML Web services that return XML data from different data sources. A data retrieval service is installed and runs on a server extended with Windows SharePoint Services. Windows SharePoint Services comes with a default set of data retrieval services for working with data in SharePoint lists, OLEDB, and XML data sources. Client applications and data-bound Web Parts, such as the Spreadsheet Web Part, can use a data retrieval service to query the data source supported by the particular data source.
Note
If your data retrieval service is attempting to connect to a remote Microsoft SQL Server database that is configured to use Microsoft Windows authentication, the server with the data retrieval service, the remote server running SQL Server, and the client initially making the request against the data retrieval service must be using Kerberos authentication. For more information about setting up Kerberos authentication, see the Help system for Internet Information Services (IIS) 6.0.
The data retrieval services properties are part of the setproperty and getproperty operations. The syntax for the setproperty operation is:
stsadm -o setproperty
-propertyname <property name>
-propertyvalue <property value>
**\[-url\]** \<https://server\_name\>
The syntax for the getproperty operation is:
stsadm -o getproperty
-propertyname <property name>
**\[-url\]** \<https://server\_name\>
Note
You can substitute -pn for -propertyname and -pv for -propertyvalue.
The following table describes the data retrieval services properties.
| Property name | Description |
|---|---|
Data-retrieval-services-enabled: Stsadm property (Windows SharePoint Services) |
Turns data retrieval services on or off. |
Data-retrieval-services-inherit: Stsadm property (Windows SharePoint Services) |
Specifies whether the Web application inherits data retrieval service settings that are located on the SharePoint Central Administration Web site. |
Data-retrieval-services-response-size: Stsadm property (Windows SharePoint Services) |
Specifies the response size of the data source that is returned to the data retrieval service. |
Data-retrieval-services-timeout: Stsadm property (Windows SharePoint Services) |
Specifies the request time out setting. |
Data-retrieval-services-update: Stsadm property (Windows SharePoint Services) |
Turns the support for update queries on or off. |
Data-source-controls-enabled: Stsadm property (Windows SharePoint Services) |
Turns the data source controls on the server on or off. |
Data-retrieval-services-oledb-providers |
Obsolete. |