Publication Properties, Agent Security
The Agent Security page of the Publication Properties dialog box allows you to access the settings for the accounts under which the following agents run and make connections to the computers in a replication topology:
- The Snapshot Agent for all publications.
- The Log Reader Agent for all transactional publications. There is one Log Reader Agent for each database published for transactional replication. Changing the Log Reader Agent settings affects all transactional publications in a database.
- The Queue Reader Agent for transactional publications that allow queued updating subscriptions. There is one Queue Reader Agent for each distribution database. Changing the Queue Reader Agent settings affects all transactional publications with queued updating subscriptions that use the same distribution database. For more information about Queue Reader Agent security settings, see How to: View and Modify Replication Security Settings (SQL Server Management Studio).
For more information about security settings and the permissions required by each agent, see Replication Agent Security Model.
Options
- Security settings or Create Agent
If an agent job has been created, click Security settings to access a dialog box that allows you to change the security settings for an agent. If an agent job has not been created, click Create Agent to create one and specify security settings.
See Also
Other Resources
How to: Create a Publication and Define Articles (SQL Server Management Studio)
How to: View and Modify Publication and Article Properties (SQL Server Management Studio)
Publishing Data and Database Objects
Replication Properties
Replication Wizards
Replication Security Best Practices
Security Considerations for Replication