sql-serverreplicationtransactional-replication

SQL Replication 'The process could not connect to Distributor' between vps and laptop

I have 1 SQL server 2017 in London (VPS) and I connect with remote on port 1413 with 'sa' user , that work perfect. I config Distributor and Publisher successfully as shown as on server B : Publisher and Distributor successfully

And create subscriber on server A (my Laptop) as shown as bellow: create subscriber

And subscriber created and started successfully but after 30 seconds show error 'The process could not connect to Distributor' as shown as : enter image description here

Additional information:' (from User sa) refused because the job is already running from a request by User sa. Changed database context to 'PUB4'. (.Net SqlClient Data Provider)'

Solution

  • This tutorial video solves my problem for best way login to distributor. And path snapshot folder must be path share folder with users, Like: \\DESKTOP-7Cxxx\myfolderForSnapshot else cant create snapshot file.