In SQL replication, what are the minimum rights/roles for the @subscriber_login used in sp_addpushsubscription_agent?

I'm configuring SQL 2008 R2 Transactional Replication (with non-updatable subscriptions).

I'm using the sp_addpushsubscription_agent system stored procedure to configure the push subscription agent on the publisher.

I need to specify the @subscriber_login so that the agent can connect to the subscriber machine to push it updates.

What are the minimum roles/rights that this user requires on the subscriber server?

Is db_owner role membership in the subscription database sufficient?

I've scoured the documentation for this but nothing jumps out at me.

asked Jun 23 '10 at 04:50 PM in Default

Kev
14 ● 4 ● 5 ● 6

(comments are locked)

1 answer:

check this link out, I recently used the information to give minimum rights for a pull subscription

or for 2005

answered Jun 23 '10 at 08:35 PM

Daniel Ross
2.9k ● 6 ● 10 ● 12

(comments are locked)

Your answer

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Topics:

asked: Jun 23 '10 at 04:50 PM

Seen: 1882 times

Last Updated: Jun 23 '10 at 04:50 PM