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.
Publication Access List (PAL)
Logins and groups are given access to publications through the PAL. Manage the PAL through SQL Server Management Studio or programmatically:
- SQL Server Management Studio: How to: Manage Logins in the Publication Access List (SQL Server Management Studio)
- Replication Transact-SQL programming: How to: Manage Logins in the Publication Access List (Replication Transact-SQL Programming)
For more information about the PAL, see Securing the Publisher.
Snapshot Agent
There is one Snapshot Agent for each publication.
- SQL Server Management Studio: How to: Create a Publication and Define Articles (SQL Server Management Studio)
- Replication Transact-SQL programming: How to: Create a Publication (Replication Transact-SQL Programming)
- RMO programming: How to: Create a Publication (RMO Programming)
FTP Snapshot Delivery
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:
- SQL Server Management Studio: How to: Deliver a Snapshot Through FTP (SQL Server Management Studio)
- Replication Transact-SQL programming: How to: Deliver a Snapshot Through FTP (SQL Server Management Studio)
Log Reader Agent
There is one Log Reader Agent for each database published for transactional replication.
- SQL Server Management Studio: How to: Create a Publication and Define Articles (SQL Server Management Studio)
- Replication Transact-SQL programming: How to: Create a Publication (Replication Transact-SQL Programming)
- RMO programming: How to: Create a Publication (RMO Programming)
Queue Reader Agent
There is one Queue Reader Agent for all Publishers and publications (that allow queued updating subscriptions) associated with a given Distributor.
- SQL Server Management Studio: How to: Enable Updating Subscriptions for Transactional Publications (SQL Server Management Studio)
- Replication Transact-SQL programming: How to: Enable Updating Subscriptions for Transactional Publications (Replication Transact-SQL Programming)
See Also
Tasks
How to: View and Modify Replication Security Settings (SQL Server Management Studio)
Concepts
Replication Security Best Practices
Other Resources
Security Considerations for Replication
How to: View and Modify Replication Security Settings (Replication Transact-SQL Programming)