Post reply

Replication & Service Accounts

  • July 7, 2015 at 12:10 am

    #398702

    Hi,

    I want to set up the transactional replication. How many service accounts we need and what kind of permissions it required in windows level?

    Only two servers we are using. Pub/Distributor and Subsciber.

    Which option is better Push or pull?

  • July 7, 2015 at 2:53 am

    #1810633

    Hi, there are lots of articles and "how to's" around and I suggest you have a look.

    I tend to use a separate account for the agents (different from the service and agent account) and this account will have specific permissions such as dbowner on the subscriber only, access to the file system that contains the replication files i.e. snapshot.

    You could go mad and have a separate account for each agent which is not a bad thing, it just adds a little extra complexity.

    Your setup sounds like a pretty straightforward arrangement.

    Graeme

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

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