June 10, 2011 at 5:24 pm
Hello all,
I have 2 serevr (server 1 and server 2 and both are sql 2008) that are confugured for transactional replication for a database 1. I am trying to confugure the replication between the same publisher and subscriber (here the publisher and distrubuter are on same server).
I configured the publisher and after that when I saw the replication monitor the log reader agent is not working and is throwing an error message and below is the one:
The process could not execute 'sp_replcmds' on 'Publisher server name'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)
Get help: http://help/MSSQL_REPL20011
Could not obtain information about Windows NT group/user 'CORP\326202', error code 0x5. (Source: MSSQLServer, Error number: 15404)
Get help: http://help/15404
The process could not execute 'sp_replcmds' on 'Publisher User'. (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)
Get help: http://help/MSSQL_REPL22037
When I tried to delete the publisher using the sp_droppublication script I am getting the belwo error:
Msg 15404, Level 16, State 19, Procedure sp_replcmds, Line 1
Could not obtain information about Windows NT group/user 'CORP\326202', error code 0x5.
The sql sever service and agent service are running under admin rights and they have the sysadmin privilages and the login that I used to configure the replication has also the sysadmin rights. I make the snapshot folder sharable and gave the write permission to sql service and agent service logins. I just configured the publisher and I am using the same distributer that was created previously for another database. I havet confgured the subscriber yet, as I am getting the error in running the log reader agent.
I want to delet the publisher and wanted to start from the beginning. I cant execute sp_removepublication as the server has another publisher that is successfully running now .
Please let me know what to do and how to proceesd
Thanks a lot for your help
February 13, 2012 at 2:32 am
I'm too facing very much similar issue in one of our development servers. Please help me get out of that annoying message. Thanks!!!!
February 13, 2012 at 8:53 am
Did you remove the subscriptions first?I always make sure that I drop subscriptions before removing a publication.
Jared
CE - Microsoft
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply