I want to setup transactional replication on sql server. By following the instructions of the ms replication preparation tutorial and the ms replication configuration tutorial, everything works fine.

My question is: Why all these 4 users? Will there be any trouble if instead of 4 I only use one windows user/db login for every step?


If you use 1 user, you typically end up giving that user more access than it needs. By having the example use 4 different users, it helps demonstrate the good practice of using dedicated accounts for particular purposes. If one is compromised, there’s less impact on the overall system. If the example used just one user, everyone would assume it had to be that way.

| improve this answer | |
  • OK, I understand your comments about "good practice", which is of course what the tutorial should instruct. However, this also implies that there is no concern (security aside), of damaging the functionality. Right? – George Menoutis Oct 8 '18 at 10:24
  • Correct. Functionally you could use a single account. – Rob Farley Oct 8 '18 at 12:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.