Database-connection-timeout: Stsadm property (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

Description

Retrieves an open connection or sets a connection to a Microsoft SQL Server database.

Syntax

stsadm -o setproperty

-propertyname database-connection-timeout

-propertyvalue <A valid time, in seconds>

**\[-url\]** *\<https://server\_name\>*

The syntax for the getproperty operation is:

stsadm -o getproperty

propertyname database-connection-timeout

**\[-url\]** *\<https://server\_name\>*

Note

You can substitute -pn for -propertyname and -pv for -propertyvalue.

Values

The following table shows possible values.

Name Value

propertyname

Gets or sets the name of the property.

propertyvalue

A valid time, in seconds. The default value is 15 seconds.

A value of zero indicates no limit, and should be avoided because an attempt to execute this value will wait indefinitely.

url

Typically, a path to the URL of the Web application, in the form http://server_name.

Examples

To set the timeout value to a connection to 45 seconds, use the following syntax:

stsadm -o setproperty -pn database-connection-timeout -pv 45

To view the current setting of the database-connection-timeout property, use the following syntax:

stsadm -o getproperty -pn database-connection-timeout