1

I can't resolve a problem with replication. The publisher/distribution side seems just fine, but when I subscribe and view in the replication monitor I always get this error: "a required privilege is not held by the client"

I thought I had it figured out with an MSDN article explaining the SQL Agent user/pw needs to be set in SQL Config Mgr (instead of Windows Services) -- that was peculiar, but it did describe our situation. Then, we reset the user/pw using SQL Config Manager and I still get the same error.

I deleted my subscription, and setup a new one, but still the same error.

FWIW the publisher/distributor is SQL Server 2008 and the subscriber is 2012 (doing pull subscriptions).

  • 1
    With SSCM you might actually try setting to local system (applying and restarting) and then put it back to the account you want it to be. It does not necessarily apply the permissions to everything by just applying a password. – Shawn Melton Nov 25 '14 at 22:29
1

This is a permissions issue and you can find more details in the verbose agent log.

Verify that your replication agent process accounts have the necessary permissions listed in the section Permissions That Are Required by Agents in Replication Agent Security Model.

Note that Microsoft recommends that you use a Windows accounts for replication agent process accounts. Do not impersonate the SQL Server Agent account when you create the subscription, use a Windows account.

The Distribution Agent process account for a pull subscription requires:

  • Member of db_owner in the subscription database.

The account that is used to connect to the Distributor requires:

  • Be a member of the PAL.
  • Have read permissions on the snapshot share.
  • This did come down to permissions. There were a few things going on with a few different cooks in the kitchen (having different roles, and views on things). Thank you for your answer. – Chris Adragna Jan 30 '15 at 15:50

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.