|
Property
|
Characteristic
|
|
One or multiple alternate database servers. An IP address or server name identifying each server is required. Port number and the connection property DatabaseName are optional. If the port number is unspecified, the port number specified for the primary server is used.
If a port number is unspecified for the primary server, the default port number of 1433 is used.
|
|
|
Number of times the driver retries the primary database server, and if specified, alternate servers until a successful connection is established.
The default is 5.
|
|
|
Wait interval, in seconds, between connection retry attempts when the ConnectionRetryCount property is set to a positive integer.
The default is 1.
|
|
|
Determines whether the driver fails the entire failover process or continues with the process if exceptions occur while trying to reestablish a lost connection.
The default is nonAtomic (the driver continues with the failover process and posts any exceptions on the statement on which they occur).
|
|
|
The failover method you want the driver to use.
The default is connect (connection failover is used).
|
|
|
Specifies whether the driver tries to connect to the primary and an alternate server at the same time.
The default is false (the driver tries to connect to an alternate server only when failover is caused by an unsuccessful connection attempt or a lost connection).
|
|
|
Sets whether the driver will use client load balancing in its attempts to connect to the database servers (primary and alternate). If client load balancing is enabled, the driver uses a random pattern instead of a sequential pattern in its attempts to connect.
The default is false (client load balancing is disabled).
|
|
|
Determines whether the driver attempts parallel connections to the failover IP addresses of an Availability Group during initial connection or a multi-subnet failover. When MultiSubnetFailover is enabled, the driver simultaneously attempts to connect to all IP addresses associated with the Availability Group listener when establishing an initial connection or reconnecting after a connection is broken or the listener IP address becomes unavailable. The first IP address to successfully respond to the request is used for the connection. Using parallel-connection attempts offers improved response time over traditional failover, which attempts to connect to alternate servers one at a time.
The default is false (disabled).
|