Export (0) Print
Expand All

Setting Logins and Passwords When Creating Publications

This topic covers the following areas related to creating publications:

  • Publication access list (PAL)

  • Snapshot agent

  • FTP snapshot delivery

  • Log Reader Agent (for transactional publications)

  • Queue Reader Agent (for transactional publications with queued updating subscriptions)

For information about the permissions required by each agent, see Replication Agent Security Model.

Logins and groups are given access to publications through the PAL. Manage the PAL through SQL Server Management Studio or programmatically:

For more information about the PAL, see Securing the Publisher.

If you specify that snapshots should be made available through an FTP share rather than a UNC share, you must specify a login and password when configuring FTP access:

There is one Log Reader Agent for each database published for transactional replication.

There is one Queue Reader Agent for all Publishers and publications (that allow queued updating subscriptions) associated with a given Distributor.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft