Merge Replication via Firewall

[chongtl]

I have 2 SQL 2000 servers. In head office, I setup SQL 2000 and it is behind a firewall. In remote office has 1 SQL 2000 server. No firewall at remote office.

I tried to subscribe the database from Remote office. It failed. Error message is the script cannot propagate to subscriber. In Head office, the database is publish for Merge replication.

At the Firewall, I already open port 1433. There is no problem for remote office to register the Head office SQL under its SQL manager.

Do I need to open other ports for the replication ? What port?

Hope someone can help. Thanks

 

[tlbroadbent]

Have you reviewed the topic in SQL BOL?

Implementing Replication Over the Internet

http://msdn.microsoft.com/library/en-us/replsql/replimpl_51v8.asp

Security and Replication Over the Internet

http://msdn.microsoft.com/library/en-us/replsql/replsec_5ad0.asp

Check this article.

INF: TCP Ports Needed for Communication to SQL Server Through a Firewall

http://support.microsoft.com/default.aspx?scid=KB;en-us;287932

This link may also be helpful.

http://groups.google.com/groups?selm=eTcx7wP9BHA.2512@tkmsftngp05

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.