Thursday, November 18, 2010

MSSQL: the process could not execute 'sp_replcmds'

Platform:
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:
  1. Select "Databases", open "Object Explorer Details"(shortcut F7), you can see the current owner for every database.
  2. Change the owner to sa as script below:
    •  sp_changedbowner ''
  3. Repeat step 1, click refresh button to check the new database owner.
  4. Reinitialize the publications by click "Reinitialize All Subscriptions" .