MultiSubnetFailover Property

In This Topic

Specifies whether to enable faster failover for all Availability Groups and or Failover Cluster Instance in SQL Server 2012.

Syntax

Visual Basic
C#

'Declaration
 
Public Property MultiSubnetFailover As Boolean

public bool MultiSubnetFailover {get; set;}

Property Value

true, if a connection must attempt connections in parallel for multi-subnet failover or aggressively retry the TCP connection for a subnet failover; otherwise, false.

Remarks

It is recommended to set this property to true when connecting to SQL Server 2012 availability group listener or SQL Server 2012 Failover Cluster Instance. Set this property to false when connecting to anything other than SQL Server 2012 availability group listener or SQL Server 2012 Failover Cluster Instance (default value).

This property must not be used when the FailoverPartner property is set.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

SqlConnectionStringBuilder Class
SqlConnectionStringBuilder Members

Send Feedback