Monday, February 20, 2012

Problem with peer to peer replication across a VPN

We are experiencing some problems with peer to peer replication configuration across a VPN between a 32 bit and 64 bit SQL server 2005. We have been able to configure it but we notice that on successful completion of the configuration the 64 bit machine does not have a subscription for the 32 bit machine article. But both servers have articles created and only the 32 bit machine has a subscription. This is a bizarre experience because the configuration was successful.

We know the server windows account has administrative rights at both end and we can telnet each server successful and all the necessary ports are open.

Might feeling is that the firewall or VPN us acting up but I cannot prove it..

I need help or advice about how to resolve this…

I assume you configure the P2P using P2P wizard. When you go through the wizard, in the summary page, do you see replication indiciate it will create subscription from 64bit machine to 32 machine?

Peng

No comments:

Post a Comment