How to connect to a AlwaysOn read only replica with Sql Sentry Plan Explorer? It does not seem to have any options to specify ApplicationIntent=ReadOnly
When I try to connect, it gives me this error:
Unable to connect to ServerName.
Reason: The target database ('DbName') is in an availability group and is currently accessible for connections when the application intent is set to read only. For more information about application intent, see SQL Server Books Online.