Home Forums SQL Server 2016 SQL Server 2016 - Administration sql server cluster and ag node RE: sql server cluster and ag node
Beatrix Kiddo
SSC-Dedicated
Points: 32407
More actions
May 3, 2018 at 5:38 am
#1989054
Cool you should be ok then. You''ll need to specifically configure read-only routing, by the way. It's not as simple as just enabling the read-only attribute within the AG. (Sorry if that seems obvious, but a lot of people miss it.)
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-read-only-routing-for-an-availability-group-sql-server?view=sql-server-2017