Sample Header Ad - 728x90

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 enter image description here
Asked by mohammad kamali (101 rep)
Apr 13, 2023, 08:10 AM
Last activity: Apr 16, 2023, 03:08 PM