Data Retrieval Services: Stsadm properties (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

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.


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] <http://server_name>

The syntax for the getproperty operation is:

stsadm -o getproperty

-propertyname <property name>

[-url] <http://server_name>


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 (Office SharePoint Server)

Turns data retrieval services on or off.

Data-retrieval-services-inherit: Stsadm property (Office SharePoint Server)

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 (Office SharePoint Server)

Specifies the response size of the data source that is returned to the data retrieval service.

Data-retrieval-services-timeout: Stsadm property (Office SharePoint Server)

Specifies the request time out setting.

Data-retrieval-services-update: Stsadm property (Office SharePoint Server)

Turns the support for update queries on or off.

Data-source-controls-enabled: Stsadm property (Office SharePoint Server)

Turns the data source controls on the server on or off.