Home Library Wiki Learn Downloads Support Forums Blogs
Sign in | United States - English | |

Database-connection-timeout: Stsadm property (Office SharePoint Server)

Updated: December 20, 2007

Applies To: Office SharePoint Server 2007

Updated: 2007-12-20

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

The syntax for the getproperty operation is:

stsadm -o getproperty

   propertyname database-connection-timeout

   [-url] <http://server_name>

Note 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

Community Content Add
Annotations FAQ
Restart after changing this value?

Does this require IISRESET or any other services to be restarted?

History
Missing "dash" character in GetProperty syntax
The dash character (-) is missing from in front of the syntax for GetProperty as shown above. Thankfully, the examples use the correct syntax. The page should be changed to include the missing dash character so that it reads:

The syntax for the getproperty operation is:

stsadm -o getproperty
-propertyname database-connection-timeout
[-url] <http://server_name>


History