Just had this exact same issue and fixed it by following the steps from here:
https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-security-configure?view=azuresql