Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL 2012 Enterprise Peer to Peer over VPN

Posted on 2014-02-16
6
Medium Priority
?
209 Views
Last Modified: 2014-02-26
Hey guys

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?
0
Comment
Question by:jonmenefee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
6 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 39863151
without seeing the sql server's errorlog and eventually some relevant windows eventlog, it won't be easy to troubleshoot such kind of issues.
0
 

Author Comment

by:jonmenefee
ID: 39863173
True.  I will start monitoring the logs and the connection.  When I see it go down again I will look at those logs and post what I think the error is.
0
 
LVL 5

Expert Comment

by:cheers4beers
ID: 39863287
I agree with Guy, additional info is needed.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:jonmenefee
ID: 39863304
today I have restarted both servers several times and right after the restart I can connect but the connection only last a few minutes and then any time I do an expansion of the other server within the MSSMS it will time out and say the connection is no longer there.  For example.  When I am logged into the Houston server and open MSSMS and connect to the Houston SQL server its fine, but when I go to Open Database connection to the Dallas SQL server it connects just fine and expands all the directories.  Within a few minutes though when I try to go back into the Dallas SQL server and expand the folders (Management for example) and if it expands and I try to view a log file it times out and says the Server name is no longer available.  
Very strange eh?
0
 

Accepted Solution

by:
jonmenefee earned 0 total points
ID: 39877518
Ok, turns out the problem was all DNS and Keberos.  The server in Dallas was messed up and wouldn't allow authentication.  I forced it to be demoted and all my problems went away.
0
 

Author Closing Comment

by:jonmenefee
ID: 39888281
Not a great answer but unfortunately no one else offered much.  It wasn't their fault... nothing in my problem suggested DNS
0

Featured Post

Enroll in September's Course of the Month

This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question