Solved

VPN to client on work network

Posted on 2013-01-04
5
684 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Remote Desktop Connections allow you to control remote host machines via the magic of the Internet and RDP (Remote Desktop Protocol). For the purposes of this article we will assume you are connecting from your home PC or laptop to a remote offic…
If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
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…

932 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

8 Experts available now in Live!

Get 1:1 Help Now