The process could not execute 'sp_replcmds' on 'WINTESTSQL2'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)
I have the same error on SQL Server 2012, after configured replication according to Microsoft technet turorials http://technet.microsoft.com/en-us/library/aa337475.aspx http://technet.microsoft.com/en-us/library/aa337437.aspx
I have distributor, publisher and subscriber all on the same SQL Server instance for a test.
The errors are The process could not execute 'sp_replcmds' on 'HOMSAR\WULU2012'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Get help: http://help/MSSQL_REPL20011 Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission. (Source: MSSQLServer, Error number: 15517) Get help: http://help/15517 The process could not execute 'sp_replcmds' on 'HOMSAR\WULU2012'. (Source: MSSQL_REPL, Error number: MSSQL_REPL22037) Get help: http://help/MSSQL_REPL22037
I checked the databases on the instance with select name ,suser_sname(owner_sid) owner from sys.databases
All databases has a valid owner, and the repl_logreader Windows login has db_owner role in publisher, subscriber and distribution databases.
Appreciate any comments, suggestions and solutions.
answered Sep 20 '13 at 06:56 PM
Is replication working normally?
I would check to see if all the database have valid owners on WINTESTSQL2 and I guess WINTESTSQL1
If any of your DBs have NULL then you will need to resolve this first. See here
answered Aug 01 '12 at 07:41 AM