Configure SQL Server merge replication in local machine and a server machines
0
votes
0
answers
160
views
I have two databases on my local machine and the server. I want to sync them whenever they are being changed. For my scenario I'm using SQL Server replication.
I use merge type to sync these databases twoway. I'm placing the distributor in my server and I have created publisher is my server. And the publisher is running when I'm reaching it from replication monitor.
On my local machine, I have created a subscriber to that publisher but I can't connect to my publisher.
I followed these steps to solve this problem.
- I have turned off my firewalls in both machines
- SQL Server browsing is running in both machines
- Remote connection is enabled on both
- TCP is enabled on both
- I don't have any errors in SQL Server logs in neither of them
- SQL Server service is running on both
I'm stuck in a loop and do not know what to do to make it work.
Do you have any ideas how I can make it work?
Is it possible at all to connect them when I'm using local machine and server?
***UPDATE***
I Find out that they have to be in the same network and as my local machine doesn't have any ip address I tried to use OpenSSH for reverse tunneling and i didn't reach any result
***UPDATE_2***
after i tried to connect via static ip address, i can ping my subscriber on my publication machine via telnet but in replication monitor i get this error

Asked by mohammad kamali
(101 rep)
Apr 13, 2023, 08:10 AM
Last activity: Apr 16, 2023, 03:08 PM
Last activity: Apr 16, 2023, 03:08 PM