| Property |
Default Value |
Description |
| Connect Timeout
-or-
Connection Timeout
|
15 |
The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. |
| Connection Lifetime |
0 |
When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by Connection Lifetime. This is useful in clustered configurations to force load balancing between a running server and a server just brought online. A value of zero (0) causes pooled connections to have the maximum connection timeout. |
| Context Connection |
'false' |
'true' if in-process connection to SQL Server should be made. |
| Connection Reset |
'true' |
Determines whether the database connection is reset when being removed from the pool. Setting to 'false' avoids making an additional server round-trip when obtaining a connection, but the programmer must be aware that the connection state is not being reset. |
| Current Language |
|
The SQL Server Language record name. |
| Data Source
-or-
Server
-or-
Address
-or-
Addr
-or-
Network Address
|
|
The name or network address of the instance of SQL Server to be connected. The port number can be specified after the server name: server=tcp:servername, portnumber. When specifying a local instance, always use (local). To force a protocol, add one of the following prefixes: np:(local), tcp:(local), lpc:(local)
ADO.NET 2.0 does not support asynchronous commands over shared memory for SQL Server 2000 or earlier. However, you can force the use of TCP instead of shared memory, either by prefixing tcp: to the server name in the connection string, or by using localhost.
|
| Failover Partner |
N/A |
The name of the failover partner server where database mirroring is configured. The Failover Partner keyword is not supported by .NET Framework version 1.0 or 1.1. |
| Initial Catalog
-or-
Database
|
|
The name of the database. |
| Load Balance Timeout |
0 |
The minimum time, in seconds, for the connection to live in the connection pool before being destroyed. |
| Integrated Security
-or-
Trusted_Connection
|
'false' |
Determines whether the connection is a secure connection or not. Recognized values are 'true', 'false', and 'sspi', which is equivalent to 'true'. |
| Max Pool Size |
100 |
The maximum number of connections allowed in the pool. |
| Min Pool Size |
0 |
The minimum number of connections allowed in the pool. |
| Packet Size |
8192 |
Size in bytes of the network packets used to communicate with an instance of SQL Server. |
| Password
-or-
Pwd
|
|
The password for the SQL Server account login. Not used with (strongly recommended) 'Integrated Security=true' option. |
| Persist Security Info |
'false' |
When set to 'false' (strongly recommended), security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state. Resetting the connection string resets all connection string values, including the password. |
| Pooling |
'true' |
When 'true', the SQLConnection object is drawn from the appropriate pool, or if necessary, is created and added to the appropriate pool. Recognized values are true, false, yes, and no. |
| Replication |
'false' |
'true' if replication is supported using the connection. |
| Transaction Binding |
Implicit Unbind |
Controls connection association with an enlisted System.Transactions transaction. Possible values are:
Transaction Binding=Implicit Unbind;
Transaction Binding=Explicit Unbind;
Implicit Unbind causes the connection to detach from the transaction when it ends. After detaching, additional requests on the connection are performed in autocommit mode. The System.Transactions.transaction.Current property is not checked when executing requests while the transaction is active. After the transaction has ended, additional requests are performed in autocommit mode.
Explicit Unbind causes the connection to remain attached to the transaction until the connection is closed or an explicit SqlConnection.TransactionEnlist(null) is called. An InvalidOperationException is thrown if Transaction.Current is not the enlisted transaction or if the enlisted transaction is not active.
|
| TrustServerCertificate |
'false' |
When set to 'true', SSL is used to encrypt the channel when bypassing walking the certificate chain to validate trust. If TrustServerCertificate is set to true and Encrypt is set to false, the channel is not encrypted. Recognized values are true, false, yes, and no. |
| User ID |
|
The SQL Server login account. |