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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy