Connect a remote notebook application via internet to an application on an office network

When the staff is in the office, they connect a notebook to a DB application on an XP Pro PC via a wireless network. When they leave the local office to work in a remote office, they download a copy of the DB to the notebook and go to work at the remote office. The DB application allows synchronization when they arrive back at the local affice and login to the application via the wireless network. I want them to be able to accomplish the synchronization over the internet so that they do not always have to return to the local office. Does anyone have any suggestions on the best way (least costly) way to accomplish this?
Who is Participating?
Rob WilliamsConnect With a Mentor Commented:
>>"Port 1723 is not necessary if if pptp is an option on the router"
If the option of using a router exists, then all of the PPTP options above are of no consequence. <G> The instructions are for a Windows VPN server using PPTP which requires port 1723 be forwarded.
If using a router is an option, in most cases you would use IPSec instead of PPTP, and one of the benefits of using a router is no ports need to be forwarded. As each router is configured differently we would need to know make and model to provide more information, if you have a router that supports direct connection by a VPN.
The best way is to set up a VPN connection and the laptop will think it's in the local office and sync properly and securely.
ThomasoMAuthor Commented:
Thank you Victor. Can you point me to a resource that will help me define a VPN?
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

What operating system are you running on your server? What routers do you have between your server and the internet?

Here's a link to a bunch of resources for configuring a Windows 2003 Server VPN:

Rob WilliamsCommented:
As suggested a VPN is probably the best bet. You could also use an FTP server but there can be security risks with that. The VPN can be set up with a VPN router and client, or you can use the built in Windows VPN. Excellent instructions ca be found at the following sites:
Windows 2003 VPN server
The client end can be configured with the following:
This can be configured with other versions of Windows. Please advise if you need instructions, or you can find most here:

You will also have to forward port 1723 on the router at the 'server' end to the computer acting as a VPN server. Finally on the same router you need to enable PPTP pass-through. This could be called GRE, PPTP or VPN pass-through depending on the router.You can find specific information as to how to configure port forwarding for your router at:
Click on the link for your router and on the resulting page click on the link for "Point to Point Tunneling Protocol"

If you don't have a static public IP address at the office you can also use a DDNS (Dynamic Domain Name Services) such as to deal with the changing

If you want to look at the router and client option the Linksys RV042 is a very affordable choice:
Port 1723 is not necessary if pptp is an option on the router.
Rob WilliamsCommented:
Thanks ThomasoM,
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.

All Courses

From novice to tech pro — start learning today.