Setting up Transactional Replication in SQL Server 2008 R2.
8. A new window appears as shown in the screen capture below.
9. Specify the distribution agent to run under the SQL Server Agent Service Account. Also connect to the distributor as well as the subscriber by impersonating the process account. Please refer the screen capture below.
10. Click on the OK button as shown in the screen capture above.
11. Click on the Next> button as shown in the screen capture below.
12. Ensure that the Agent is scheduled to Run Continuously and then click on the Next> button as shown in the screen capture below.
13. Ensure that the Subscriber is initialized immediately and then click on the Next> button as shown in the screen capture below.
14. Click on the Next> button as shown in the screen capture below.
15. Click on the Finish button as shown in the screen capture below.
16. This creates a subscriber for the corresponding publisher.
17. Expand the publisher node and you shall be able to view the subscriber as shown in the screen capture
Thus, we have successfully set the Transactional Replication in SQL Server 2008 R2.
Well Done. Simple but yet descriptive.
Thank you for this. Have been looking for a clean explanation of setup.
Nice stuff, Walked me through a full setup for my class model.
Thanks very much
James
complete step by step explanation. Good job..
thank you , but you didnot added this subscribtion in another server as you told us at the first of the lesson
Thanks a lot This is very useful for me. Once again say thanks for this kind of assistance.
Thanks a lot for the step-by-step setup!!
Helped me very much.
Thank you very much, your explanation helped me a lot
Great job 
Thanks for your efforts and wonderful explanation!
Thanks a lot. Good job.
Nice post!
zee
http://walisystemsinc.com
Nice, helped me very much.
Christian
Thank for your Article!!!!
helped me Very Much
Thank you good one
this is really helpfull
thanks
Siraj
Could you please elaborate why you chose to ignore the security recommendations to choose separate accounts other than the service account?
excellent job very very thanful to you for this tutorial sir .
thanks a lot
i could like to have more tutorial
owesom doccument.it is very easy to understand…thanks a lot
Nice one..really helpful
The publisher doesn’t/shouldn’t care about the exact location of the subscriber’s database files, right? For example, once the subscriber has been set up and replication has been going on for some time, if I move the database files underlying the subscriber database, will that break the transaction replication?
Very Nice Job; Thanks a lot. I wonder if this procedure can be done with SQL Express? I know it’s not but maybe there is a way to tweak the application.
Great tutorial, got me started real quick. Thanks Satnam!
Excellent tutorial. Thank you very much.
Need to Know more on “Always On High Availability ” Feature. its new to task to me in SQL Server 2012.