Agent Security (New Publication Wizard)

 

Applies To: SQL Server 2016

The Agent Security page allows you to specify 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.

  • The Queue Reader Agent for transactional publications that allow updatable subscriptions. The Microsoft SQL Server Agent job for this agent is created if you specified Transactional publication with updatable subscriptions on the Publication Type page, regardless of the type of updatable subscriptions you use. For more information about updatable subscriptions, see Updatable Subscriptions for Transactional Replication.

For information about permissions required by agents and best practices for replication security, see Replication Agent Security Model and Replication Security Best Practices.

Snapshot Agent
Displayed for all publications. Click Security Settings to specify security settings in the Snapshot Agent Security dialog box.

Click Help on the Snapshot Agent Security dialog box for more information about the permissions required for accounts used by the Snapshot Agent.

Log Reader Agent
Displayed for all transactional publications. Click Security Settings to specify security settings in the Log Reader Agent Security dialog box.

Click Help on the Log Reader Agent Security dialog box for more information about the permissions required for accounts used by the Log Reader Agent.

System_CAPS_ICON_note.jpg Note


There is one Log Reader Agent for each database that is published using transactional replication. If a transactional publication already exists in the database, the security settings are read-only. You can change the settings in the Publication Properties dialog box, but changes affect all transactional publications in the database.

Queue Reader Agent
Displayed for transactional publications that allow updatable subscriptions. Click Security Settings to specify security settings in the Queue Reader Agent Security dialog box. A Queue Reader Agent job is created when this wizard completes; it does not depend on you creating any queued updating subscriptions. If you do not plan to create any queued updating subscriptions, you can disable the job. Right-click the job (named in the form: [<Publisher>].<integer>.) in the SQL Server Agent Jobs folder, and then click Disable.

Click Help on the Queue Reader Agent Security dialog box for more information about the permissions required for accounts used by the Queue Reader Agent.

System_CAPS_ICON_note.jpg Note


There is one Queue Reader Agent for each distribution database (and all Publishers that it serves). If a transactional publication that allows queued updating subscriptions already exists on any of the Publishers that use a given distribution database, the security settings are read-only. You can change the account under which the Queue Reader Agent runs and makes connections in the Distributor Properties dialog box, but changes affect publications at all Publishers that use the distribution database.

Create a Publication
Create an Updatable Subscription to a Transactional Publication
View and Modify Distributor and Publisher Properties
View and Modify Publication Properties
Manage Logins and Passwords in Replication
Publish Data and Database Objects
Replication Agents Overview

Community Additions

ADD
Show: