Quickbooks Pro Over SonicWall VPN

Posted on 2011-05-12
Last Modified: 2012-05-11
I have a client who currently has QB Pro 2010 and two users using the company files over a LAN.  They want to add a server to their network and VPN capability for a remote user (CFO) to access Quickbooks from a remote office via internet.

I have read several articles about setting up Remote Services on the server, that only QB Enterprise edition will work over the WAN, etc.

This is a small business that will not spend 3000.00 for QB Enterprise so that one user can access remotely.

It seems that there must be a way to setup something using the following equipment:

Dell Poweredge T310 server
SonicWall TZ200 for VPN
Remote user has a laptop with ADSL connectivity to internet
Multi User License for QB Pro 2010

Any ideas on EXACTLY what to do in this case??
Question by:mjoiner
    LVL 89

    Accepted Solution

    Running QB Pro over a VPN is dangerous. You can very easily trash a ledger that way. For QB Pro and Premier (not Enterprise), you can set up QuickBooks on a workstation and provide remote access to the workstation. That way the remote user is using a local (office) copy of QuickBooks with the ledger on the server. That way will work, and I do that for clients.  ... Thinkpads_User
    LVL 25

    Assisted Solution

    by:Tony Giangreco
    Yes, I agree with thinkpads_user. If you have a connection break while the QB file is open, it could cause corruption in the company file. i'd suggest installing QB on a workstation at the facility and intall Logmein free which provides them full access to log onto that PC's desktop and run quickbooks and all other applications. If they need to print reports, they can either upgrade to Logmein pro or create PDF based reports and send them out as attatchments by email to an account they can loginto from home.

    I see this quite a bit. QB can be a big hit on a small company.
    LVL 89

    Expert Comment

    by:John Hurst
    Ordinary RDP to the facility workstation also works if VPN is already in place. There are various approaches to remote access. ... Thinkpads_User
    LVL 25

    Expert Comment

    by:Tony Giangreco
    RDP for the office mgr is too complicated.

    Author Comment

    After studying up on RDP and looking at the cost considerations for giving one remote user access, I think I am leaning toward purchasing a computer simply for the purpose of installing QB and logmein pro.  I think this would be a good solution until they needed to provide terminal services to more users.  And from what I understand, the only version of Quickbooks that is supported over RDP is enterprise.  And tha is like 2500.00!  Quite a big jump from QB Pro.

    Thanks to those who have answered.
    LVL 89

    Expert Comment

    by:John Hurst
    Thank you. I was happy to assist and good luck going forward. ... Thinkpads_User

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Suggested Solutions

    I was supporting a handful of Windows 2008 (non-R2) 2 node clusters with shared quorum disks. Some had SQL 2008 installed and some were just a vendor application that we supported. For the purposes of this article it doesn’t really matter which so w…
    If you use NetMotion Mobility on your PC and plan to upgrade to Windows 10, it may not work unless you take these steps.
    This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
    This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

    729 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

    22 Experts available now in Live!

    Get 1:1 Help Now