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 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;
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!
you’re in reality a just right webmaster. The website loading pace is amazing. It seems that you’re doing any distinctive trick. In addition, The contents are masterpiece. you have performed a fantastic activity in this subject!
you have a great blog here! would you like to make some invite posts on my blog?