The application intent connection string property expresses the client application's request to be directed either to a read-write or read-only version of an availability group database. 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.

Data Type

string

Default Value

"ReadWrite"

Remarks

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