Replication - SQLServer Agent uses System Account

  • When I attempt to set up replication on my local box, I receive the error -'SQLServer Agent uses the Systems Account, which causes replication betweem servers to fail'.

    Why does this happen? And can I overcome this?

    Thanks 🙂

    Bianca

  • If you are replicating bettween differents servers on your network, you must use a Domain Account for you SQL Agent service account. Otherwise, you won't be able to replicate.

    Use local system accout only to replicate for example, bettween two different databases in the same server.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply