Setup and Configure Transactional Replication with a Remote Distributor SQL Server - Step by Step

Best to watch this at 1080p or 720p minimum

How to properly setup/configure transactional replication with a remote distributor for SQL Server. This video shows how to do it on a real Windows Domain with active directory. Three servers are used - one for the Publisher, one for the Distributor, and one for the Subscriber.

It also uses proper user security to lockdown the privileges of the replication agents.

It use Windows Server 2019 and SQL Server 2017

[CodeFast-mv]

The best ever tutorial on transactional replication setup !!!!

[pradeepgovindasamy]

Perfect video . One thing I felt missing is, you could have shown respective replication jobs in publisher server, distributor server and subscription server . And those job owners as well ...

[DOSdaze]

Thank you for actually showing how to setup proper permissions. So many of these walk throughs are all on a single local box using an admin account for everything... hard to learn and understand whats actually going on that way. This helped me more than anything else in getting my multi-domain environment replicating the way I wanted it to.

[LamNguyen-qbic]

Thank you so much. It's very good explanation and right to the points. I keep watching over and over to refresh my memory from time to time.

[pradeepgovindasamy]

If you have time please put up video for configuration translation replication for always on servers, really it is very easy to understand for us the way you are explaining is awasome..

[weneedheros]

Really useful and a very good description. Thank you for taking the time to make this video.

[mt-nulj]

Great tutorial. It is real life scenario. A lot of tutorials are running on AgentAccount and lector doesn't show and explain AD users topic

[LamNguyen-qbic]

Thank you. It's clear and straight to the points.

[Shivanis]

Great video. Thanks for sharing. Please share video like this for Migration steps for SQL server 2016 to SQL 2017/SQL 2019.

[plinioj]

Excellent video. Very well explained and easy to follow

[matawill]

What a great video!!! It works perfectly. Quick question if I have separate servers that I want to set up as new publications using the same subscriber server. Do I need to create separé distributors?

[badrslaoui]

very nice explanation helped me a lot thanks

[winnarno]

after right-clicking on the replication menu there is no 'configure distribution' option, there is a 'publisher propertise ' ?

[lirusme]

thanks for sharing, but how if SQL server instance using custom port? please advice

[NaaneVinu]

Thank you so much for the video. Hope you doing great.

I have a production database that is maintained by vendor and we have restrictions to use tables but only views. Vendor has provided one-to-one indexed views to access those tables.


Now I would like to have replica of the database in another accesble network, where also I have no restrictions on the database.


1. Is it possible to do transactional replication on indexed views? ([Source]Indexed views -> [Destination]Indexed views)?

2. In the above case, is it also possible to convert [Destination]Indexed views to a table instead of views?

If possible can you also please create a video on this as well?

Thank you. Have great holidays. 😊

[MotionInMotion]

Incredibly well explained. Two questions if u dont mind: 1) Can this be done with SQL Express? and 2) Is it absolutely necessary to have Active Directory installed? Thanks.

[amaurygermano]

Hi, I have the same scenario and it's working fine. Could you help me how can I move the distributor to another new server? I have 8 groups with 5 thousand tables replicated and I don't like to lose the data has replicated. Thanks

[moigonzaga]

Quick question... I have set up a server to be a distributor which I'm going to call "Server D". I have another server "Server P" that I want to be my Publisher. That SQL Server didn't have the "Replication" module installed, so I went to execute the installer, modify the instance, and then installed the Replication component. So, as far as I know, I don't need to restart the whole server.

Then I went to the Replication folder, right rick on "Local Publications">New Publication, I selected the database, configure the security, and assigned a name to my Transactional Replication.

The problem is that I'm getting an error when executing the first action (creating de Publication) and it says "This database is not enabled for publication. Unable to execute procedure. The database is not published. Execute the procedure in a database that is published for replication. Changed database context to 'MYDB_NAME'. (.Net SqlClient Data Provider)" and the whole process fails.

Is there anything that I may be missing on the Publisher server? Thanks a lot with any feedback!

[bertthings]

How to solve this issue after publisher set up "proxy domain/user is not a valid windows user". Thank you

[mohammadredoyhossain]

I don't understand about domain concept? Is it mandatory my all three server in same series IP address series?