We are trying to setup replication in sql server 2000 environment.We are trying to transactional replicate across 2 sql server 2000 databases in different data centres through VPN.
Is anyone aware of what ports the distribution agent uses that needs to be opened for firewall? What would be the best way to pull the initial schema and data snapshot across non trusted data centres through VPN and firewall?
Your help is very much appreciated. Thanks for your time.