Attribute

ApplicationIntent (AI)

Purpose

Specifies whether the driver connects to read-write databases or requests read-only routing to connect to read-only database replicas. Read-only routing only applies to connections in Microsoft SQL Server 2012 where Always On Availability Groups have been deployed.

Valid Values

0 | 1

Behavior

If set to 0 (READWRITE), the driver connects to a read-write node in the Always On environment.

If set to 1 (READONLY), the driver requests read-only routing and connects to the read-only database replicas specified by the server.

Notes

  • By setting ApplicationIntent to 1 (ReadOnly) and querying read-only database replicas when possible, you can improve efficiency of your environment by reducing the work load on read-write nodes.
  • When ApplicationIntent is enabled, the virtual network name (VNN) of the availability group listener must be specified in the Host Name connection option.

Default

0 (READWRITE)

GUI Tab

Advanced tab