As mentioned in my previous post, In this post, let us see step by step tutorial in configuring subscriber at server 3
In SSMS - > Under Object Explorer - > Replication -> Local Subscriptions -> New Subscriptions...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiK3f0DUCmrh7qw-IwRoXSJd6CNkDN1m3KKKt6MNLAWfozYwengWyABQjLSKGqkrV2KG8xURk17IUMqP95ZRdK9rdXsk61EFVnBsbLTqwipxwj8hOage7ygYyDqEIy4ldLh_eVrxlvoEttB/s640/1.PNG)
Choose Publisher:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRI8MB4cxFhIcRviS-JbZg8R_JYTE28sWjC0lu8p_m49u4tvMRERGkD99xEYsN2mcjAbuXtOlMFZIpyjesz66u2bRZCCR0QJb0a_ZnkKlj3rJHzIiG0dcyR0eJ5UEX6TjjXS9bRb722yVj/s640/2.PNG)
The Distribution Agent runs at the Distributor for push subscriptions and at the Subscriber for pull subscriptions.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfpQReNDd55vKI3D0r91pi6lXa4_Ugsvd9suGMXaeSENtXMarxO_bDzG1tZmaDLZjmEgNMTBDH6OFbMiEWrEwcgHec31TVOUc02_wbKjnIB4j8TTJ-bYXbeerUh6wWpxu6RMPaMHGePuAK/s640/3.PNG)
Add Server 3 as Subscriber:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwgpKhhtWDhOY8wtXLf4d1cfTzAOsfGLkqUsgq6_4Afi6KVczxtW0nEPlwQ8gfwp9vBrKx5Xu7Z35bKnY3PPYOegDMuxoDaWWfFMxKioqfyKLyFTKIO2g42IL2h_CSHuYPtIZd-zYPwivH/s640/4.PNG)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpFRAtTcce0bby0eB4G4XHSp_v3SOO9fSn299txqT_LA7hbnCyeeZ8GORwgIOMr5TkNfbbnzt63xu9FXSYWNMYQK8gBx9pmTMwe2PAhjDpvp0Iu8jYFB_I8xBKf-RdqVLmHaM9No5QBs_7/s640/5.PNG)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglQt4PDUeN8ujnfytXdQkkwyHLNf4GRYPJ560mldqPmfTe7HxI1q-G9rBfu6iaeNToHf1WkmgqvA4c_6oWvugOWy9XYESZs-uXhKp9qTZsWJcNF-1YW3D5EwV5n1rZAF4KgRwX_wuUuqZq/s640/6.PNG)
Provide path for saving Configuration scripts and click Finish.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNB1c8VGmJ7S-MZeRVi7_aRVjSYixaLjAhF8rkacbEiyUOF6qeoG1yi3I-Z55D-UmB-eGXTjorwOB38z6jz2iRuvI1P_hFxc0nL6XYhJjABKVQNArqx9OnWjq-ofTfvZQEaeeQQ42jTbSZ/s640/7.PNG)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHbIlFBPJ8zfYPg1ew5fDWWDOgb-rMaIDl93TpMgMtLXxMMay8KbuFsuNBAJ8N1z4l6jAYQJXgoqLMbPHMHoh1xcry1j5eEsdQj0II3C3cWz3Hw01JeMLBGbxAsLNMkm0DCla0aAFUUpgb/s640/8.PNG)
In SSMS - > Under Object Explorer - > Replication -> Local Subscriptions -> New Subscriptions...
Choose Publisher:
The Distribution Agent runs at the Distributor for push subscriptions and at the Subscriber for pull subscriptions.
Add Server 3 as Subscriber:
Provide path for saving Configuration scripts and click Finish.
No comments:
Post a Comment