Change replicationAgent that starts SQLSERVERAGENT

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wingman - 30 Dec 2005 16:07 GMT

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?

Wingman

Reply to this Message

Hilary Cotter - 30 Dec 2005 17:06 GMT

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.

Signature

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

> Hi,
>
[quoted text clipped - 8 lines]
>
> Wingman

Reply to this Message

Wingman - 30 Dec 2005 19:19 GMT

Thanks as always.

Wing

> Hi,
>
[quoted text clipped - 6 lines]
>
> Wingman

Reply to this Message