x

Error while monitoring Replication

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
more ▼

asked Jul 31, 2012 at 09:12 PM in Default

Chitrarekha gravatar image

Chitrarekha
140 34 42 43

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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]
more ▼

answered Aug 01, 2012 at 07:41 AM

sp_lock gravatar image

sp_lock
9.3k 26 28 31

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Sep 20, 2013 at 06:56 PM

luggg gravatar image

luggg
90 7 9 11

I would suggest asking this as a new question rather than as an answer to a year-old question
Sep 20, 2013 at 07:02 PM KenJ
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x306

asked: Jul 31, 2012 at 09:12 PM

Seen: 1125 times

Last Updated: Sep 20, 2013 at 07:02 PM