Microsoft SQL server
Error:
While replications, the Log Reader Agent status shown "the process could not execute 'sp_replcmds'...
Solution:
Change database owner to sa.
Step:
- Select "Databases", open "Object Explorer Details"(shortcut F7), you can see the current owner for every database.
- Change the owner to sa as script below:
- sp_changedbowner '
' - Repeat step 1, click refresh button to check the new database owner.
- Reinitialize the publications by click "Reinitialize All Subscriptions" .