Edit

Distribution Agent Security (Peer-to-Peer Replication)

  • Article

Applies to: SQL Server

The Distribution Agent Security page allows you to specify the accounts under which the Distribution Agent runs and makes connections to the computers in a peer-to-peer topology. For information on permissions required by agents and best practices for replication security, see Replication Agent Security Model and Replication Security Best Practices.

Note

If the Distribution Agent for a subscription has already been configured in a previous run of this wizard, you cannot change the credentials it uses in this wizard. If you specify new credentials, they are ignored. To change credentials, use the Subscription Properties dialog box. For more information, see View and Modify Replication Security Settings.

Options

Click the properties button (...) in the row for each Subscriber to access the Distribution Agent Security dialog box. Click Help on the Distribution Agent Security dialog box that is launched for more information on the permissions required for accounts used by the agents.

After settings have been entered in one of the dialog boxes, connection information for the Subscriber is displayed in the grid.

Agent for Subscriber
The name of each peer.

Peer Database
The database at the peer that will serve as both a publication database and subscription database.

Connection to Distributor
The context under which the connection to the Distributor is made. Local connections are always made using the context of the Windows account under which the agent runs. This wizard creates push subscriptions (the local connection is the connection to the Distributor), so this field will always display: Impersonate '<Domain>\<Login>' or Impersonate '<Computer>\<Login>'.

Connection to Subscriber
The context under which the connection to the Subscriber is made. The connection can be made using the context of the Windows account under which the agent runs or under the context of a SQL Server login. The field displays one of the following: Use login '<Login>', Impersonate '<Domain>\<Login>' or Impersonate '<Computer>\<Login>'. Microsoft recommends that all connections be made using the context of the Windows account.

See Also

Administer a Peer-to-Peer Topology (Replication Transact-SQL Programming)
Peer-to-Peer Transactional Replication