Connecting to ReadOnly Secondary Replica of SQL Server via the Listener by Default
Question We have the ApplicationIntent=ReadOnly properly routing our users to the Secondary ReadOnly replica. Is there a way to make this the default behavior? Apparently the default behavior seems to be ReadWrite, and if you don’t specify an ApplicationIntent it will redirect to the Primary … [Read More]