I'm facing a strange issue in one of my availability replicas. Always on is runing on SQL Server 2017. The availability group is composed of two nodes. I was checking the owner user of both replicas and here comes the issue. In the primary node the owner is the user that was configured to that purpose:
replica_server_name ag_name owner_sid name
-------------------------------------------------------------
XXXXXXDB11 XXXXXHA11 0xB31XXXXXX usr_sql_xxxx
My surprize was that when the other replica was checked the owner is public role
replica_server_name ag_name owner_sid name
--------------------------------------------------
XXXXXXDB12 XXXXXHA12 0x02 public
Does any body has a clue why in one of my replicas the owner is public role?