Menu

Database Replication – Part III

11. February 2018 - Ashwini Tripathi
This post was originally published on this site

This post is in continuation to my earlier post. Please check if you missed.

Database Replication – Part I

Database Replication – Part II

As committed in this post we will continue to cover practical approach, Next step from last post.

Configuring Distribution

We will configure distribution at the Publisher and set the required permissions on the publication and distribution databases. If you have already configured the Distributor, you must first disable publishing and distribution before you begin this process. Do not do this if you must retain an existing replication topology.

Configuring a Publisher with a remote Distributor is outside the scope of this Post.

If you have connected to SQL Server using localhost rather than the actual server name you will be prompted with a warning that SQL Server is unable to connect to server ‘localhost’. Click OK on the warning dialog. In the Connect to Server dialog change the Server name from localhost to the name of your server. Click Connect.

Configuring distribution at the Publisher

DR-10

DR-11

DR-12

DR-13

DR-14DR-15DR-16DR-17DR-18

DR-19

Setting database permissions at the Publisher

DR-20

DR-21

DR-22

 

DR-23

 

Here we complete configuring our Distribution at Publisher.

We will see next step in our next post.