Link to home
Create AccountLog in
Avatar of rexxnet
rexxnetFlag for United States of America

asked on

How do I speed up a vpn connection when transferring files from the server to an offsite location?

Here's the goal.  I have two marinas that I am setting up that will have Server 2003 for Small Business Server running in a remote office in NC.  The two marinas are in SC.  I will be sharing a quickbooks file with them from the server in NC.  The only way I can connect is through a VPN and it is VERY slow.  Right now, the data file is barely over 7 megs.  That's tiny for quickbooks.  It takes near 10 minutes to load it up.  The broadband upload speed at the server site is 768kbps.  It's as fast as they can get.  This is very rural.  Any ideas on what can be done?  The customer isn't able to afford terminal server.  Even if he was, I wouldn't know how to set it up.  Is there another vpn client out there besides what is built into windows that would be faster?

Thanks!

Rexx
Avatar of Anthony1982
Anthony1982

VPN connection is all based on your internet speed. The client plays a very small role. The only way your going to speed it up is to try and see if they will bump up your upload/download.
Avatar of rexxnet

ASKER

Yeah.  That's what I'm trying to tell him.  He's not hearing me.  LOL.  What is this terminal server thing?  Someone told me that would be much better.  
ASKER CERTIFIED SOLUTION
Avatar of Cliff Galiher
Cliff Galiher
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
When using terminal services or the suggested spare PC option ( depends how many users you have needing access ) printing can be a little awkward however it is made a little easier in the Server 2008 implementation. I tend to use network printers at the remote site and then you can add them directly to the host machine by IP and thus you connect from remote to HQ you control the PC at HQ and choose print in the app and then it prints to the printer by direct IP at remote.

There are other products such as PC anyware or even tight VPN all doing remote control of an HQ PC, however RDP over VPN I find really ticks the box.
PC Anywhere, TightVNC, etc are great for screen sharing and administrative tasks, but weren't really designed or intended for the purpose being discussed, hence the issues with printing, etc. There is a difference between sharing a screen that is visible at the location being connected to and getting your own sandboxed session such as what RDP provides. This is why even MS has two separate "products" in their client OS's. Remote Desktop is a TS/RDS connection where "Remote Assistance" is a screen-sharing connection similar to PC-Anywhere or TightVNC. Again, understanding what each technology is geared for is key to making the right decision on which to implement.
-Cliff
 
Avatar of rexxnet

ASKER

Thanks everyone for your input.  I have a good idea of what some of these things are now.  Let me throw in a kicker and see where we go.  I'm learning as we go along if you couldn't tell.  

Here's how the marinas are set up.  They MUST have quickbooks installed and running so a marina software called scribble can access the datafile through quickbooks that is housed on the server in their main office.  While RDP is great and others like  logmein free  version just to view  and manipulate your machine you log in to, the software does not  work that way.  It has to attach to the quickbooks data file.  The only way to do that is through some type of vpn connection to allow access to the shared resources on the server.  I have mapped the quickbooks folder as a network drive and pointed quickbooks and scribble to that file.  

Does that really throw a wrench in there or what???  I think I smell at least a T1 with static IP.  Don't you all?
Avatar of rexxnet

ASKER

OH...and another wrench.  There are three marinas connecting simultaneously.  Good news is, the system will only send a batch file to the quickbooks data file on a schedule when the business is closed.  Good news about that is while it is taking forever to  upload the data to the server, no one will be there pull.ing out their hair.  The only realtime transaction that will write itself into quickbooks is an outbound payment.  Otherwise, the POS (scribble) software just writes data into itself and then batches it into quickbooks.  that's the only time the quickbooks file is used heavily.
As previously mentioned, RDP is *NOT* the same as screen sharing software such as logmein, etc. Each RDP connection on an RDS server is a unique log in, just as if it were a separate machine, thus file access is handled just as if separate machines were logged in. For quickbooks, that means setting u a quickboosk server and having clients connect to it (which you would do even if RDS were not involved) for multi-user setups. The only change here is that the client machines all exist in an RDS platform instead of separate physical hardware machines.
I have several sites using quickbooks in a remote desktop setup; multi-user simultaneous access using Quickbooks client/server setup. It works great and, considering the cost of a T1, would pay for itself rather quickly and be less prone to connectivity issues or data corruption that can occur when sending large amounts of data over a WAN (VPN or otherwise.)
-Cliff
 
It is loking that way, one  scenario I have come across was where the quickbooks data is actually a copy and not the same as the head office but a lunch time backup zipped and transfered accros the VPN. ( you could use some more effiecient method of getting the data there than using a zip now  and could look into this if it were a workable solution )

You would need to think this through carefully and see if using stale data at the remote site achieves your goal.

Even if you bump the line speed you may still not get the perfomance you are after, you might findit worth getting in touch with someone live www.expand.com or riverbed. ( I do not work for these guys )
Avatar of rexxnet

ASKER

Thanks IntegrityOffice and everyone.  I really appreciate all of your suggestions.  With the limited resources he has as well as the ruralness (made a word), they may have to just suck it up or find an offsite system.
I should have clarified a bit by the way, if I were going to roll out RDS, I'd sandbox the entire thing, scribble and all. If scribble is running on the RDS server as well then it has access to the quickbooks data at LAN speeds and thus sidesteps the entire situation.