Availability Group Properties/New Availability Group (General Page)
SQL Server 2012
This topic applies to the General tab of both the New Availability Group dialog box and the Availability Group Properties dialog box. The New Availability Group dialog box enables you to create a new availability group without using the New Availability Group Wizard. The Availability Group Properties dialog box enables you to view and alter the configuration of an existing availability group.
Automatic failover. The replica is a target for automatic failovers. This is supported only if the availability mode is set to synchronous commit.
Manual failover. The replica can only be failed over to manually by the database administrator.
Connections in Primary Role
The type of client connections supported when the replica owns the primary role.
Allow all connections
All connections are allowed to the databases in the primary replica. This is the default setting.
Allow read/write connections
Connections where the Application Intent connection property is set to ReadOnly are disallowed. When the Application Intent property is set to ReadWrite or the Application Intent connection property is not set, the connection is allowed. For more information about Application Intent connection property, see Using Connection String Keywords with SQL Server Native Client.
Whether an availability replica that is performing the secondary role (that is, a secondary replica) can accept connections from clients, one of:
No direct connections are allowed to secondary databases of this replica. They are not available for read access. This is the default setting.
Only direct read-only connections are allowed to secondary databases of this replica. The secondary database(s) are all available for read access.
All connections are allowed to secondary databases of this replica, but only for read access. The secondary database(s) are all available for read access.
Session Timeout (seconds)
The number of seconds for the session-timeout period on this replica.