Share via


Distribution Agent Security (peer-to-peer replication)

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 How to: View and Modify Replication Security Settings (SQL Server Management Studio).

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

Other Resources

How to: Configure Peer-to-Peer Transactional Replication (SQL Server Management Studio)
How to: Administer a Peer-to-Peer Topology (Replication Transact-SQL Programming)
Peer-to-Peer Transactional Replication
Replication Properties
Replication Wizards

Help and Information

Getting SQL Server 2005 Assistance