I want to configure replication between my office and hosting company, where we hosted our application with its databases.
We are able to replicate from my office to hosting company server, by allowing hosting company IP address in our firewall.
When we want to do the same, from hosting company server to my office, it is not able to connect to my server. Note that we have a public IP address, through which connection should be established. But this IP address is not a server / machine, just an IP. Also inside our office there are many SQL Server instances and we want to connect to one of them.
Independent of replication, I am able to connect to hosting company SQL Server using SSMS in my Office Server. But when I do the same using remote desktop connection of hosting company server to connect to SQL Server in my office, I failed.