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).

Azure SQL Database

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

Azure SQL Server

Azure SQL DB

Azure SQL Database

Similar Posts

One Comment

  1. I think other website proprietors should take this website as an model, very clean and magnificent user friendly style and design, as well as the content. You’re an expert in this topic!

Leave a Reply

Your email address will not be published. Required fields are marked *