| Database-connection-timeout: Stsadm property (Office SharePoint Server) | |
|
|
| Stsadm command-line tool (Office SharePoint Server) > Stsadm properties (Office SharePoint Server) > General: Stsadm properties (Office SharePoint Server) > |
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.
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: |
|---|
| 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