Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003

    Unanswered: Accounts to use for replication

    I am setting up Replication and have a question about what's considered best practice for the accounts that will be running the replication agents. Microsoft says, “Run each replication agent under a different Windows account, and use Windows Authentication for all replication agent connections.” What they don't say is whether these accounts are local accounts or domain accounts.

    Which should I use/create, domain accounts or local accounts?

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    I've always used AD accounts on the distributor, and local service accounts on the publisher and the subscribers. I could probably make a good case for using AD accounts for every Windows Authenticated account used in a domain if for no other reason than it would serve as good documentaiton.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts