Specifies whether the connection requests a read-write or read-only session when connecting through an Availability Group listener.

Data Type

string

Default Value

"ReadWrite"

Remarks

Set ApplicationIntent to ReadOnly to enable read-only routing.

When the listener receives this value, it forwards the connection to a readable secondary replica, provided one is configured and online.

If you omit the property or leave it at the default value ReadWrite, the listener directs the connection to the primary replica and allows full read-write operations.