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 not allowing the replication to be completed. After altering the owner to sa account, the log reader started automatically, and the tables were imported in target db .
ALTER AUTHORIZATION ON DATABASE::AdventureWorksLT2019 to sa;