[Webinar] Streamline your web hosting managementRegister Today


VPN to client on work network

Posted on 2013-01-04
Medium Priority
Last Modified: 2013-01-04

I have a working VPN to my work network that allows me to connect just fine to my server (SBS2011 Essentials). Mapped drives on my laptop are successfully mapped once the VPN is connected.

However I need access to a mapped drive on a client PC because the shared folders uses Quickbooks sharing, software that will only work on SBS 2008 or earlier or in our case Windows 7 Pro. It works perfectly in house.

My router currently forwards VPN-PPTP to the server ip address.

Ideally i would like to connect to both server and the client at the same time if possible

If not I could create another mapping to a different port and the relevant IP address, would this work?

Question by:Gordon710
  • 3
  • 2
LVL 78

Expert Comment

by:Rob Williams
ID: 38744340
Are you wanting to run QuickBooks locally and connect to the data at the corporate site via VPN?  If so, this is not supported due to the slow Internet connection. QuickBooks requires the data be on the same LAN.  Accessing any database of this type over a VPN is very slow and due to the fact that they are so 'chatty' it will often result in data los or corruption. Even a wireless LAN connection is not officially supported by QuickBooks.

The best bet for remote access to QuickBooks is a terminal server or PC to which you can logon using Remote Web Access, through SBS Essentials.  This keeps the data at the corporate site for security and only sends screen refreshes to the remote client, not data.

From the QuickBooks site:
Minimum network requirements:
  100 Mbps network card
  100 Mbps switch or router
  40 Mbps network bandwidth

This is not achievable via the internet/VPN

Author Comment

ID: 38744393
That's exactly what I wanted to do.

What you say makes sense, though both ends of the Inter-network are just short of 40Mbps (Superfast or FTTC) and I wanted to try to see if it would work.

Since my posting I've been trying to access anything on the particular PC via vpn but cannot. Other PC's I can so I guess it's down to permissions.

Thanks for you help anyway.
LVL 78

Accepted Solution

Rob Williams earned 2000 total points
ID: 38744521
I assume 40Mbps is the download speed and that assumes everything between the two sites is just as fast, upload is usually much less, and is actually the determining factor.  Even so it is still far below minimum requirements.

Having said that, it will connect, it will work, and it will be slow, however at any point and time you can have data corruption and require a restore from backup or database repair.

I am pretty negative, am I not  :-)
Sorry, it is just this is a very common question and the answers are always the same.

As for answering you actual question....
The problem is usually 1 of two issues, routing or firewalls.  
-If you have a default VPN configuration it shouldn't be a routing issue and you have confirmed you can connect to other PC's which should verify routing is OK.
-Can you ping the PC in question?  Software firewalls will often block connections from outside of the LAN/Domain. Most often pings (ICMP requests) are  allowed, but services such as file and print, and RDP, are only allowed from the local LAN.  As a test is it possible to disable the Windows firewall and any other 3rd party security service on the PC hosting the QuickBooks data?

When you try to connect and it fails, what do you receive as an error message?

Author Closing Comment

ID: 38744550
I appreciate your help with this but even when I succeed in establishing the connection you don't sound too hopeful of it being viable (at least reliably so).

I've been messing about trying to establish a connection all afternoon and it's not essential so rather than waste any more of your time I've decided to accept your recommendations not to pursue it further.

Thanks for your help.

LVL 78

Expert Comment

by:Rob Williams
ID: 38744591
Thanks Gordon.

SBS Essentials is a great product in that it has built-in and pre-configured "Remote Web Access" which will allow you to connect to any server or PC in the office to which you have been granted permissions.  This allows you to work as if in front of the console, keeps data secure, and performs extremely well even on a slow connection.  Many folk as a solution for your problem set up a dedicated physical or virtual PC/s for remote users.  A terminal server is the ideal solution if you have more than a few remote users.

Details regarding final configuration of RWA:

Featured Post

SMB Security Just Got a Layer Stronger

WatchGuard acquires Percipient Networks to extend protection to the DNS layer, further increasing the value of Total Security Suite.  Learn more about what this means for you and how you can improve your security with WatchGuard today!

Question has a verified solution.

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

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…
I recently attended Cisco Live! in Las Vegas, a conference that boasted over 28,000 techies in attendance, and a week of hands-on learning hosted by a solid partner with which Concerto goes to market.  Every year, Cisco displays cutting-edge technol…
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…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

591 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