Process of creating subscription

This article provides step by step configuring  publication in SQL Server 2008R2

     1. Open SQL Server Management Studio, connect to the publishing server and expand the Replication folder.

     2. Inside the replication folder, right click Local Subscriptions and choose New Subscription from the  pop-up menu.

     3. Inside the replication folder, right click Local Subscriptions and choose New Subscription from the pop-up menu.

     4. Click ‘Next’ on the New Subscription Wizard welcome page.

     5. Then it will display publication screen, select the publication database and click ‘Next’ button to continue.

   
     6. Then, Select whether you wish to create a push or pull subscription and Continue. Here with pull subscription.

     7. On the subscribers window, select the subscriber database and click ‘Next’ to continue

     8. On the Merge Agent Security page, click … and enter the security account settings details.

 

Merge agent security settings 

 

     9. On the Synchronization schedule window, keep the defaults and click ‘Next’ to continue.

     10. On the Initialize Subscriptions page, keep the defaults and click ‘Next’ to continue.

 

      11. Select the Subscription type and click ‘Next’ button.

     12. Then Enter the Host_Name value and click ‘Next’ button.

     13. On the Wizard Actions window, select the action when you click finish and click ’Next’ to continue.

     14. On the Complete the Wizard page, review the subscription settings and click Finish to create the subscription. SQL Server will provide a status window informing you of its progress creating the new subscription.