Solved

vpn vs direct RDP to SQL box

Posted on 2016-08-22
2
63 Views
Last Modified: 2016-08-24
when you connect to a network via VPN and then connect through SSMS to a SQL Server

vs

when you connect to a network via VPN and then connect to a SQL Server via RDP and then use SSMS

what are the pros and cons, from your experience?
which was faster etc. for file transfers or other operations..
do you try to avoid VPN when possible, like above possible scenarios..
from SQL server (database operation perspective) what aspect of VPN can be made better or room for improvement for better performance/working(user)experience?
0
Comment
Question by:25112
2 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 250 total points
ID: 41765459
I connect to all of my customers remotely, so I use the VPN and RDP every day, numerous times.

>>what are the pros and cons, from your experience?
Pros -- it works.  Assuming you have the proper authentication set up at the targeted domain, it is very manageable, and works well.
Cons -- You need to be careful that you don't use multiple VPNs at once.  I have done this before and found my local resolution becomes suspect.  I can often times not hit the server names and have to go in by IP.  There are other complications as well, so just make sure you only use one VPN at a time.

>>which was faster etc. for file transfers or other operations..
You are comparing apples to oranges.  VPN and RDP are not one and the same. You do not have to use VPN to RDP, but if you are RDPing over a VPN session, it is very likely the additional layer will slow the operation.

>>do you try to avoid VPN when possible, like above possible scenarios..
No.  Again, I handle all of my customers remotely, so in many cases VPN is a requirement.  As long as it is managed correctly in the targeted domain, and you're using it right on your end, I don't see any reason to avoid it.

>>from SQL server (database operation perspective) what aspect of VPN can be made better or room for improvement for better performance/working(user)experience?
I would be inclined to say interaction between multiple VPNs.  But I say this because sometimes I need to hop on another customer's site for some reason, and it can be inconvenient if I have to close one customer's session down first, in order to do so.  Aside from that, I don't really have any problems with VPN, or anything that I believe should be changed/improved.
0
 
LVL 26

Assisted Solution

by:Zberteoc
Zberteoc earned 250 total points
ID: 41765497
The main difference boils down to this:

If you use the SSMS on your local to connect to the remote SQL server obviously everything will run slower because the data from the  query request has to go to the server through the network and then the data from the result sets has to come back through the same network connection. If the results are big the impact in response time could be significant.

If you run the SSMS on the remote server everything runs locally and very fast only the screen image will come through the network, which is much less data with no performance impact.

I definitely prefer to work on the remote server.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
printer shows as offline while connected to vpn 13 38
AD Replications issues 12 44
Folder NTFS Permissions 14 67
IT Contract Fee 17 68
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now