Setting Logins and Passwords When Creating Subscriptions

This topic covers the following areas related to creating subscriptions:

  • Distribution Agent (for subscriptions to transactional publications)
  • Immediate updating subscriptions (for immediate updating subscriptions to transactional publications)
  • Merge Agent (for subscriptions to merge publications)

For information about the permissions required by each agent, see Replication Agent Security Model.

Distribution Agent

There is either one Distribution Agent per subscription (an independent agent, the default for publications created in the New Publication Wizard) or one Distribution Agent per publication database and subscription database pair (a shared agent).

To specify connection information for push subscriptions

To specify connection information for pull subscriptions

Immediate Updating Subscriptions

If a transactional publication allows immediate updating subscriptions, you must specify settings for the account replication uses to connect from the Subscriber to the Publisher.

Merge Agent

Each merge subscription has its own Merge Agent that connects to and updates both the Publisher and the Subscriber.

To specify connection information for push subscriptions

To specify connection information for pull subscriptions

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)

Help and Information

Getting SQL Server 2005 Assistance