Post reply

Permissions for Merge Replication

  • August 9, 2016 at 9:50 am

    #328857

    SQL 2014 Standard

    Merge replication problem.

    I understand and read in msdn.microsoft.com/en-us/library/ms151868(v=sql.120).aspx , in the 'Permissions That Are Required by Agents' section:

    That the Merge Agent for pull subscriptions must be a user in the distribution database or “The user can be the guest user”

    But what permissions does the user or guest need in the distribution database?

    We have had merge replication running for years. Recently Pull subscriptions began failing after some OS maintenance/reboots. The error was "You do not have the required permissions to complete the operation". I isolated the problem to the distribution database.

    Now, when I explicitly add the subscriber to the distribution database and add to db_owner role, pull replication works again. Seems like too much permissions. db_datareader & db_datawriter only did not work for subscriber and/or guest. I'm sure the subscriber was never added to the distribution database before, so they must have had access via the guest user.

    What permission does the guest user need in the distribution database?

    Thanks,

    Tom

  • August 9, 2016 at 9:41 pm

    This was removed by the editor as SPAM

  • August 10, 2016 at 7:53 am

    #1894779

    Hi Prettsons,

    Thanks for reading my post. The article you suggest is the same article I was asking about. The article says the subscriber must

    "Be a login associated with a user in the distribution database. The user can be the Guest user."

    But the article does not say what permissions the user needs.

    I've removed the subscriber from the distribution database and added the guest user to db_owner role. The pull subscriptions are working, but db_owner seems way too much permissions just to subscribe.

    So, my question remains 'what permissions does the user (or guest) need in the distribution database?'

    Thanks,

    Tom

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

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