sql server replication: Change replicationAgent that starts SQLSERVERAGENT -- sql server replication

Change replicationAgent that starts SQLSERVERAGENT

Wingman
12/30/2005 8:07:02 AM

sql server replication: Hi,

We are using Push subscription in our transactional replication setup in SQL
2K and I noticed that the SQLSERVERAGENT service is started by a local
account called replicationAgent. Is it a problem for me to change it to a
different local account? If it is ok to change it, do I need to change it
also in the subscriber computer and is it necessary that both account name
and password need to be the same?

RE: Change replicationAgent that starts SQLSERVERAGENT

Wingman
12/30/2005 11:19:03 AM

Thanks as always.

Wing

[quoted text, click to view]

Re: Change replicationAgent that starts SQLSERVERAGENT

Hilary Cotter
12/30/2005 12:06:50 PM

It is ok to change it to an account in the local administrator group, or an
account which has write permission to the default snapshot share.

Make sure that the job owner is sa otherwise it probably will not start.

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.