Msg 21892, Level 16, State 1, Procedure sp_hadr_validate_replica_hosts_as_publishers, Line 70 Unable to query sys.availability_replicas at the availability group primary associated with virtual network name 'AG2Listener' for the server names of the member replicas: error = 18456, error message = Error 18456, Level 14, State 1, Message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'..',
Recently i have configured Transactional replication on Always on availability group databases. And i came across below errors . My configuration is like below NODE1-->Orginal Pubisher and Primary replica NODE2-->Secondary replica NODE3-->Distributor server and not part of any replica NODE4--> Subscriber server. I got this error when i am running the below query after remotely login in into NODE1 server which is primary replica server and from there i connected to NODE3 server which is a distributor and i have ran the query and got the below error. So this time i have logged into the NODE3 which is a distributor server remotely and ran the below query and again i got the below error. So again i ran the sp_adddistpublisher command from the distributor server which is NODE3 and i got the below error After that i have observed one thing on the environment, if you connect to the NODE2(Original Secondary replica) right click on replication tab, you w...