Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 475
  • Last Modified:

Remote user accessing files on file server via WAN.

I have a client who wishes to have sales associates in the field access a database on their server remotely via a WAN connection. In otherwords, they have laptops and connect to the internet via a 3G connection. They need to initiate an application off of their local hard drive and access the data mapped to a network drive on the server. Is the best way to do this via a VPN or can remote desktop connections do this or is there some other way to do this? I know how to do this in the office connected locally but how can they do this remotely via an internet connection?
0
FredJRobinson
Asked:
FredJRobinson
1 Solution
 
Casey HermanCitrix EngineerCommented:
I would set up VPN and do it that way. It is encrypted.

The person will have to understand that the DB access time will go down because it is over the internet.

Casey
0
 
infolurkCommented:
You should set up a VPN for external access wether they are going to use remote desktop or another method such as ODBC or direct connection.
0
 
jodix2002Commented:
I would suggest that you use VPN since that's secure, and with VPN implementation, you can set up more resources that can be made available to remote users.

You can also setup web folders (WebDAV). Linux, MacOS X, and Windows clients can access WebDAV shares.

If you use Microsoft, you can use SharePoint server, which by the way, also uses WebDAV in one of it's modules.

I don't think I will use remote desktop for that purpose, since the users already have the app installed locally, and therefore what you need is just a remote access to that folder, not an access to a whole desktop PC. But I think it is a good idea to have a machine ready with that app installed, and make it accessible through RDP, so remote clients that do not have their laptop with them can still use the app using any other internet-connected machine.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
aoakeleyCommented:
With reference to once sentance in your question
> I have a client who wishes to have sales associates in the field access a database on their server remotely via a WAN connection

While what everyone says is true "you do need a VPN". You should also consider if the database is going to work over a WAN/VPN. If it is a file based database such as MS Access, Dataflex, Fox Pro etc then it is going to be unbearably slow over the WAN as these types of databases are not true "client-server". If the backend is some type of SQL Server then there is a chance it will work, but this is also very dependent on how the application was written.

Before you incur your client the expense and frustration of trying to make something work, that is never going to work in the end. Consult with the Database application developer as to its suitability for WAN deployment.

If the database is not suitable to un over a low bandwidth WAN/VPN. Consider a Windows 2008 Terminal Server. You can publish the application so it is just an icon on the users desktop, but only the Terminal server traffic (which is suited for low bandwidth) is transmitted over the WAN.

Andy
0
 
FredJRobinsonAuthor Commented:
Andy:

The application in question is Quickbooks 2010 which I believe has an SQL server component in it.
0
 
FredJRobinsonAuthor Commented:
Isn't Terminal server now called Remote Desktop Services and how does that differ from a remote desktop?
0
 
FredJRobinsonAuthor Commented:
If I use terminal server can I also make the terminal server and the terminal server gateway computer one and the same?
0
 
aoakeleyCommented:
QB 2010 will not run well over a VPN connection with the client on the computer and the data file on the server, unless you have a lot of bandwidth (10Mb or higher)

Yes terminal server is now called Remote Desktop Services...
Yes you can make RD Server and RD Gateway same machine

The beauty about RD in Server 2008 is you can publish a single application as a remote desktop icon, the user run it like they would run a normal all, it opens in a normal resizable windows. They do not get a whole desktop like they would in old Terminal Services on 2003.
0
 
FredJRobinsonAuthor Commented:
If QB2010 will not run well over a VPN connection then how can my customer access QB2010 remotely over a WAN such as a Verizon or ATT 3g connection?
0
 
aoakeleyCommented:
Using Remote Desktop Services it will run fine.

It will just not run with "the QB 2010 client on the remote computer and the data file on the server"

Sorry if I did not explain myself properly
0
 
FredJRobinsonAuthor Commented:
Ok, so when I start the application on the remote desktop is the applicatoin actually loading on the server at the servers speed? In otherwords remote desktop is giving me a virtual desktop connection and my pc and wan connection is only used for display purposes, correct?
0
 
aoakeleyCommented:
Exactly :)
0
 
FredJRobinsonAuthor Commented:
Is there any link you can send me to to setup a remote desktop connection from a - z?
0
 
FredJRobinsonAuthor Commented:
Wow he was great he knows exaclty what needs to be done.
0
 
aoakeleyCommented:
Glad to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now