Expresses the client application's request to be directed either to a read-write or read-only version of an availability group database.

Data Type

string

Default Value

"ReadWrite"

Remarks

To use read-only routing, a client must use an application intent of read-only in the connection string when connecting to the availability group listener. Without the read-only application intent, connections to the availability group listener are directed to the database on the primary replica.

ApplicationIntent allows you to connect to a read-only secondary when connecting to an Availability Group Listener.