I have 2 instances with SQL Server 2008R2. I would like to build Transactional replication between those servers. One is in the Local Network (Local_Instance) and the second server is over Internet (Internet_Instance). The Internet Server is running an FTP service. I have read something that I can use replication using FTP but I don't have any idea how to make this. I have built the publication but I need help to configure the suscription. The distribution database is in the Local Network.
Sql-server – SQL Server Transactional Replication over Internet
replicationsql serversql-server-2008-r2
Related Solutions
Could you try moving the distributor over on to the SQL 2008 box. Replication got much better after SQL 2005. Looks like you are using anonymous subscriptions, do you not have VPN so that servers can see each other? I am not familiar with Internet based subscribers so probably not much help on its specifics.
Yes you can. You open the FTP site in IIS and change the SSL Settings from Require to Allow.
You have to check with the owners of the FTP site if this is allowed and I would recommend to use https if possible as this way you are transmitting the username and password using cleartext
Best Answer
You have probably read that you are able to deliver the initial snapshot via FTP. This is covered in Deliver a Snapshot through FTP.
It is possible to replicate two SQL Servers across a VPN. This is covered in Publish Data over the Internet Using VPN.
Once the VPN is setup, you should be able to connect and authenticate as though the servers are on a LAN or WAN.
If you have anymore questions please let me know. I hope this helps.