SQL 2012 Enterprise Peer to Peer over VPN
Posted on 2014-02-16
I know the title looks familiar but the problem is different now.
I have 2 SQL 2012 servers on Server 2012 R2. One in Houston and one in Dallas. One Domain Controller in Houston. The servers are connected via hardware VPN. Both servers DNS entries point ONLY to the Houston DC. The servers, when working properly, are setup as Peer to Peer and the subscriptions and the distributions are working great. I can make a change in Houston or Dallas and by the time I switch to look at the other one the change has already been pushed or pulled (I am not the SQL programmer so I don't know the proper term to use)
Now, here is the problem. Every couple days I have to restart the servers because they lose connection to the other. So far I am restarting both of them (haven't tried restarting only one yet to see if the problem gets resolved). Upon restart they connect with zero issues and this lasts for about 24 hours or so. I haven't timed it yet... I probably should.
Anyways, since the VPN is hardware and I am not touching that then I have to assume that the problem is with the servers themselves. Now, they are virtual machines (in case that makes a difference) and the Domain Controller in Houston is also a Virtual Machine (using Hyper-V in both Houston and Dallas).
Any ideas why or what would cause this?