Solved

VPN to client on work network

Posted on 2013-01-04
5
682 Views
Last Modified: 2013-01-04
Hi

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?

GHB
0
Comment
Question by:Gordon710
  • 3
  • 2
5 Comments
 
LVL 77

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
http://support.quickbooks.intuit.com/support/articles/INF21187#four

This is not achievable via the internet/VPN
0
 

Author Comment

by:Gordon710
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.
0
 
LVL 77

Accepted Solution

by:
Rob Williams earned 500 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?
0
 

Author Closing Comment

by:Gordon710
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.

Gordon
0
 
LVL 77

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:
http://titlerequired.com/2011/07/15/setting-up-remote-web-access-on-sbs-2011-essentials-part-1/
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Some of you may have heard that SonicWALL has finally released an app for iOS devices giving us long awaited connectivity for our iPhone's, iPod's, and iPad's. This guide is just a quick rundown on how to get up and running quickly using the app. …
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…
How to install and configure Citrix XenApp 6.5 - Part 1. In this video tutorial we have explained step by step installation of Citrix XenApp 6.5 Server on Windows Server 2008 R2 is explained in this video. We have explained the difference between…
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…

760 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now