Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / July 2008

Tip: Looking for answers? Try searching our database.

Q: Running Windows Application over VPN

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JIM.H. - 05 Jul 2008 12:31 GMT
Running Windows Application over VPN
I have a windows application that uses SQL Server as backend.I need to
install this application to another network and make our users access it. I
have two options:
1. Do remote desktop to remote network over VPN and run application.
2. Install application into our network and let it access database in remote
network over VPN.

Do you see any advantage/disadvantage over these scenarios?
Thanks,
John Bell - 05 Jul 2008 18:06 GMT
> Running Windows Application over VPN
> I have a windows application that uses SQL Server as backend.I need to
[quoted text clipped - 8 lines]
> Do you see any advantage/disadvantage over these scenarios?
> Thanks,

Hi

The standard of the connection is going to influence the success of both
solutions, if your application can not cope with a delayed responses it is
not going to work well, using RDP may also have issues such as licencing and
if your users would need to move/retrieve files etc to the other server as
this may be a two stage process rather than just finding a local file.

If the application was a web app, then you would not have such issues!

John
JIM.H. - 06 Jul 2008 03:21 GMT
Thanks for the reply John. How about traffic over the line, if I do RDC the
only traffic would be RDP traffic, if I use application locally and access
database over VPN, would this not be using bandwidth more each time I query
the database? Your thoughts please?

> > Running Windows Application over VPN
> > I have a windows application that uses SQL Server as backend.I need to
[quoted text clipped - 20 lines]
>
> John
John Bell - 06 Jul 2008 07:35 GMT
> Thanks for the reply John. How about traffic over the line, if I do RDC
> the
[quoted text clipped - 31 lines]
>>
>> John

Hi

Thst would depend  on what your application does and how it is written, so I
can't really make that call. If you return large data sets then you should
probably go the remote desktop, although you may look at the application
design anyhow! If your application can not cope with being disconnected or a
slow response from the database that would be another reason to go with
remote desktop. The easiest way to figure it out would be to test it.. RDP
would be the quickest to install, but if you are going to have more than two
people accessing this you will need more licences.

John
JIM.H. - 06 Jul 2008 19:29 GMT
Hi John,
Thank you for your help. Based on the search, large amount of data can be
returned, it depends type of search. However, whether is it large or small
amount of data, wouldn’t RDC be always faster since the data would not be
moving over the line, it is just color/screen is transferred to client side,
whereas in VPN whole data should be transferred over the line to client?

Do you agree?

> > Thanks for the reply John. How about traffic over the line, if I do RDC
> > the
[quoted text clipped - 44 lines]
>
> John
Linchi Shea - 06 Jul 2008 21:37 GMT
Another factor to consider is how robust is your app in response to a dropped
and reconnected VPN. If it's not robust, you may be better off running it
locally and access it via RDP.

Linchi

> Hi John,
> Thank you for your help. Based on the search, large amount of data can be
[quoted text clipped - 53 lines]
> >
> > John
John Bell - 07 Jul 2008 07:42 GMT
> Hi John,
> Thank you for your help. Based on the search, large amount of data can be
[quoted text clipped - 67 lines]
>>
>> John

Hi

RDP can still suffer from connection issues. RDP is not always permitted for
general use in some organisations. If you are looking for a good user
experience you should consider a web application. If your application can
not cope with disconnections or is written to retrieve large volumes of
data, then RDP may be the better solution.

John
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.