Settings of Advanced Properties

Advanced

MultipleActiveResultSets

True

False (default)

Network Library

Named Pipes (DBNMPNTW)

Shared Memory (DBMSLPCN)

VIA (DBMSGNET)

The network library used to establish a connection to an instance of

SQL Server

.

Do not use when the

SQL Server

is resident on the local host computer, value should be blank.

Packet Size

Size in bytes of the network packets used to communicate with an instance of

SQL Server

. PacketSize may be a value in the range of 512 bytes and 32,767 bytes.

Transaction Binding

Implicit Unbind (default)

Explicit Unbind

Indicates the binding behavior of connection to the

System.Transactions

namespace.

When set to

Implicit Unbind

, the connection detaches from the transaction when it ends, switching back to autocommit mode.

When set to

Explicit Unbind

the connection remains attached to the transaction until the transaction is closed. The connection will fail if the associated transaction is not active or does not match the current transaction.

Type System Version

Latest (default)

SQL Server

2012

SQL Server

2008

SQL Server

2005

Indicates which server type system the provider will expose through the DataReader.

Connection Resiliency

ConnectRetryCount

ConnectRetryInterval

Delay between attempts to restore connection. The amount of time (in seconds) between each reconnection attempt after identifying that there was a connection failure. The value must be an integer between 1 and 60.

Context

Application Name

.Net SqlClient Data Provider

Workstation ID

The name of the workstation connecting to

SQL Server

.

Initialization

ApplicationIntent

ReadWrite (default)

ReadOnly

Asynchronous Processing

True

False (default)

When true, enables usage of the Asynchronous functionality in the .NET Framework Data Provider.

Connect Timeout

The length of time in seconds to wait for a connection to the server before ending the attempt and generating an error.

A value of 0 indicates no limit, and should be avoided in a ConnectionString because an attempt to connect waits indefinitely.

Current Language

The

SQL Server

Language record name.

Pooling

Enlist

True (default)

False

Load Balance Timeout

30 (default)

The minimum amount of time (in seconds) for this connection to live in the pool before being destroyed.

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

Load Balance Timeout

.

A value of zero (0) causes pooled connections to have the maximum connection timeout.

Max Pool Size

The maximum number of connections allowed in the pool.

Valid values are greater than or equal to 1. Values that are less than

Min Pool Size

generate an error.

Min Pool Size

1 (default)

The minimum number of connections allowed in the pool.

Valid values are greater than or equal to 0. Zero (0) in this field means that no minimum connections are initially opened.

Values that are greater than

Max Pool Size

generate an error.

PoolBlockingPeriod

Auto

AlwaysBlock

Defines the blocking period behavior for a connection pool.

When connection pooling is enabled and a timeout error or other sign-in error occurs, an exception will be thrown and subsequent connection attempts will fail for the next five seconds, the "blocking period". If the application attempts to connect within the blocking period, the first exception will be thrown again. Subsequent failures after a blocking period ends will result in a new blocking period that is twice as long as the previous blocking period, up to a maximum of one minute.

Pooling

False

When

True

, the connection object is drawn from the appropriate pool, or if necessary, is created and added to the appropriate pool.

Any newly created connection is added to the pool when closed by the application. In the next attempt to open the same connection, that connection will be drawn from the pool.

Connections are considered the same if they have the same connection string. Different connections have different connection strings.

Replication

Replication

False (default)

True

Security

Authentication

NotSpecified (default)

SqlPassword

ActiveDirectoryPassword

ActiveDirectoryIntegrated

Column Encryption Setting

Enabled

Disabled (default)

Default column encryption setting for all the commands on the connection.

Encrypt

True

False (default)

When True,

SQL Server

uses SSL encryption for all data sent between the client and server if the server has a certificate installed.

Integrated Security

True

False (default)

Whether the connection is to be a secure connection or not.

When

False

, User ID and Password are specified in the connection. When

True

, the current Windows account credentials are used for authentication.

Password

*******

Indicates the password to be used when connecting to the data source.

Persist Security Info

True

False (default)

When

False

, 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.

TrustServerCertificate

False

When

True

(and

Encrypt

is set to

True

),

SQL Server

uses SSL encryption for all data sent between the client and server without validating the server certificate.

If

TrustServerCertificate

is set to

True

and

Encrypt

is set to

False

, the channel is not encrypted.

User ID

sa

Indicates the user ID to be used when connecting to the data source.

Source

AttachDbFilename

Context Connection

True

False (default)

When

True

, indicates that the connection should be from the

SQL Server

context. Available only when running in the

SQL Server

process.

Data Source

localhost\SQLACM (default)

Indicates the name of the data source to connect to.

Failover Partner

The name or network address of the instance of

SQL Server

that acts as a failover partner.

Initial Catalog

The name of the initial catalog or database in the data source.

MultiSubnetFailover

True

False (default)

If your application is connecting to a high-availability, disaster recovery (AlwaysOn) availability group (AG) on different subnets, setting this value to

True

configures SqlConnection to provide faster detection of and connection to the (currently) active server.

TransparentNetworkIPResolution

True (default)

False

If your application connects to different networks, setting this value to

True

configures SqlConnection to provide transparent connection resolution to the currently active server, independently of the network IP topology.

When set to

True

, the application is required to retrieve all IP addresses for a particular DNS entry and attempt to connect with the first one in the list. If the connection is not established within 0.5 seconds, the application will try to connect to all other IP addresses in parallel. When the first IP address answers, the application will establish the connection with the respondent IP address.

If

MultiSubnetFailover

is set to

True

, this setting is ignored.

If

Failover Partner

is specified, this setting is ignored.

The default setting is

False

if

Authentication

is set to either

Active Directory Password

or

Active Directory Integrated

, otherwise the default setting is

True

.

User Instance

True

False (default)

Indicates whether the connection will be redirected to connect to an instance of

SQL Server

running under the user's account.