I have inherited an Availability Group and have found that a linked server was set up between the two nodes of the availability group. It is using
sa for authentication unfortunately.
Simultaneously, some of the team's developers use
sa to query the live DB. I want this to stop.
My question is:
Are linked servers in any way required by availability groups? I know I have some bespoke moving parts like Agent jobs that use the linked server to sync jobs between the two nodes. I'm more concerned about something internal to SQL Server that I might not be aware of. Anything wrong with just doing normal due diligence and changing the linked server user to use non-sa and also changing the