Log Reader Agent Error Solution on Azure SQL Database while performing transactional replication
In one of our projects for a leading banking and financial organisation, we encountered an issue while performing transactional replication. Log reader agent error could not execute ‘sp_replcmds’ on sqlserverdb (Azure SQL Server). Our analysis revealed that the database that was being replicated had a different owner than sa, and this in turn was…