Solved

vpn vs direct RDP to SQL box

Posted on 2016-08-22
2
80 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

This is an article about my experiences with remote access to my clients (so that I may serve them) and eventually to my home office system via Radmin Remote Control. I have been using remote access for over 10 years and have been improving my metho…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
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…

895 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

14 Experts available now in Live!

Get 1:1 Help Now