October 7, 2013 at 3:25 pm
I have a replication that was working fine we and then a reboot occurred and now I'm getting these error messages from replication monitor. The funny thing is I don't know why it's spitting out the user 'NA\MajAdmins' because we are using account 'NA\MajService' for the replication jobs and as the account to set up replication on publisher and subscriber servers. Publisher and Subscriber are on two different servers. Help is much appreciated! Thanks.
Error messages:
The process could not execute 'sp_replcmds' on 'Server1\MAJ'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)
Get help: http://help/MSSQL_REPL20011
Could not obtain information about Windows NT group/user 'NA\MajAdmins', error code 0xffff0002. (Source: MSSQLServer, Error number: 15404)
Get help: http://help/15404
The process could not execute 'sp_replcmds' on 'Server1\MAJ'. (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)
Get help: http://help/MSSQL_REPL22037
October 7, 2013 at 3:26 pm
fyi user account 'NA\MajService' is a domain account and has admin rights on sql and local box.
October 7, 2013 at 5:22 pm
Never mind found the resolution. Here is a KB article that zoned me into the problem. Client is currently on SP1 but latest service pack out is SP3 which this KB article was found under. The windows account was lower case and in sql it was created as uppercase. I changed the sql user account to lower case and it worked.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply