We're creating a Domain account to run our Merge Agent under, and we're trying to determine what NT permissions it requires. I can't seem to find a definitive list anywhere. Our replication configuration is:
Publisher: SQL 2008 Subscriber: SQL 2005 Replication Type: Merge Subscription Type: Pull Snapshot location: Network share on publisher
It works when we run the Merge Agent as my account, but that has administrative permissions on both the Publisher and Subscriber, as well as a host of other machines on the network. We'd like to exercise the Principle of Least Privilege, so I'm looking for the minimum privileges necessary. Thanks in advance for the help!
UPDATE: Well, for now we've followed mrdenny's advice and gave the account Full Control and DBO access. I'd still be interested in the minimum privileges necessary. I can't imagine that we're the first people to need this...