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
Microsoft SQL Server Management Studio: How to: Create a Push Subscription (SQL Server Management Studio)
Replication Transact-SQL programming: How to: Create a Push Subscription (Replication Transact-SQL Programming)
RMO programming: How to: Create a Push Subscription (RMO Programming)
To specify connection information for pull subscriptions
SQL Server Management Studio: How to: Create a Pull Subscription (SQL Server Management Studio)
Replication Transact-SQL programming: How to: Create a Pull Subscription (Replication Transact-SQL Programming)
RMO programming: How to: Create a Pull Subscription (RMO Programming)
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.
SQL Server Management Studio: How to: Create an Updatable Subscription to a Transactional Publication (SQL Server Management Studio)
Replication Transact-SQL programming: How to: Create an Updatable Subscription to a Transactional Publication (Replication Transact-SQL Programming)
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
SQL Server Management Studio: How to: Create a Push Subscription (SQL Server Management Studio)
Replication Transact-SQL programming: How to: Create a Push Subscription (Replication Transact-SQL Programming)
RMO programming: How to: Create a Push Subscription (RMO Programming)
To specify connection information for pull subscriptions
SQL Server Management Studio: How to: Create a Pull Subscription (SQL Server Management Studio)
Replication Transact-SQL programming: How to: Create a Pull Subscription (Replication Transact-SQL Programming)
RMO programming: How to: Create a Pull Subscription (RMO Programming)