December 7, 2022 at 12:00 am
Comments posted to this topic are about the item The Availability Group Secondary Connection
December 7, 2022 at 7:36 am
I took this to be a trick question, and picked the wrong end of the trick.
From the DDL viewpoint I think the authorisation is either nothing or read-only. This means that from the AG viewpoint a connection to the AG listener can be routed either nothing or read-intent queries to the secondary node. However from the instance name viewpoint a direct connection to the secondary node can issue either none or any form of read query to the DBs in the AG. But I could be wrong...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
December 13, 2022 at 5:19 pm
I don't think it's tricky. The docs show you can allow only read-intent, which is an interesting view. There might be good reasons to not allow any read-only traffic on the secondary, and I thought it was good to know that. Hence the question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply