Error while monitoring Replication

Question

Error messages:

The process could not execute 'sp_replcmds' on 'WINTESTSQL2'. (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 'WINTESTSQL2'. (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)
Get help: http://help/MSSQL\_REPL22037

Answer 1

0

Is replication working normally?

I would check to see if all the database have valid owners on WINTESTSQL2 and I guess WINTESTSQL1

select name ,suser_sname(owner_sid) from sys.databases

If any of your DBs have NULL then you will need to resolve this first. See here

ALTER AUTHORIZATION ON DATABASE:: WINTESTSQL2 TO [sa]

answered Aug 01 '12 at 07:41 AM

sp_lock
8.1k ● 20 ● 26 ● 29

(comments are locked)

Error while monitoring Replication

Follow this question

Related Questions