Tuesday, February 21, 2012

replication is in pending mode

hi guys,
I don't understand something, when I use domain account to do replication,
it's in pending mode for snapshot agent, but once I use sa account to do
replication, then it's in active mode. why can't I use domain account to
create replication?
The replication subsystem can't figure out if the domain account has rights
to start the service. A patch, not sure which one, broke this sometime ago.
I logon and register my servers in EM using the sa account and everything is
peachy.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kevin" <pearl_77@.hotmail.com> wrote in message
news:%23S%23iz20yFHA.596@.TK2MSFTNGP12.phx.gbl...
> hi guys,
> I don't understand something, when I use domain account to do
> replication, it's in pending mode for snapshot agent, but once I use sa
> account to do replication, then it's in active mode. why can't I use
> domain account to create replication?
>

No comments:

Post a Comment