VPN connecting to QuickBooks

Need some help with remote users and QuickBooks database manager. I am running QB database manager on a Dell PowerEdge and using a TZ300 SonicWall for the vpn. remote users are connecting to the network via NetExtender. They are connecting great, they see all the network files and folders. They even see the QB database files fine. The problem is when opening QB it freezes after entering the password. QB opens you can select the company to open but after password, nothing. Anyone have any ideas? I'm sure its a setting on the SonicWall that needs set. A firewall access rule or something. Any ideas would be greatly appreciated.
Ross MaddoxIT DirectorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
You cannot do this reliably . QB is a very chatty database and running a remote QB client over VPN to a server with the Company file will damage the file over time.

Either set up a computer in the office for people to access and run QB on the computer in the Office,

OR,

Put in a terminal server and run QB on the terminal server so more than one person can use the file.
3

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rob WilliamsCommented:
Agree.  QuickBooks is not supported over a VPN or any "slow network".  It states in the user documentation that it must be a LAN connection of a minimum of 54 Mbps bi-directional.  54 Mbps implies wireless is acceptable, but it is not officially supported either.
1
Ross MaddoxIT DirectorAuthor Commented:
Well damn, thanks for the insight. Guess I will be using RDP on a virtual host then.
0
Managing Security Policy in a Changing Environment

The enterprise network environment is evolving rapidly as companies extend their physical data centers to embrace cloud computing and software-defined networking. This new reality means that the challenge of managing the security policy is much more dynamic and complex.

Rob WilliamsCommented:
New documentation says 40 Mbps (note must be bi-directional, not just download speeds).  Link lists supported and unsupported networks for QuickBooks.
https://community.intuit.com/articles/1577643-recommended-networks-for-quickbooks

Other links State: "For QuickBooks Solutions, a 100 Mbps network card, a 100 Mbps switch or router and a 40 Mbps network bandwidth are required for client and server tasks. "

Some folks have made a VPN work, but in almost all cases it results in data corruption.
0
Hypercat (Deb)Commented:
RDP is a much better solution.  You don't mention it, but if multiple users are going to be working in this database at the same time, I hope you have a multi-user license installed on the server that runs QuickBooks!! The results otherwise could be pretty unpleasant.
0
Ross MaddoxIT DirectorAuthor Commented:
yes we already have the multiuser license. Thanks
0
Blue Street TechLast KnightCommented:
Hi Ross,

I'd recommend RDS (MSFT Remote Desktop Services) previously called Terminal Services but here are some other options not previously mentioned.

QuickBooks Online will drastically reduce your infrastructure requirements: procurement, complexity & management/support.
• If they have desktops you can have them VPN, then RDP into their workstation (in ConnectionScripts you can automate this process so all a user has to do is login to the VPN). The workstation would be doing all the heavy lifting in this scenario.

Also, if you continue to go down the VPN route enable 2FA (the server is built into SonicWALL)!

Let me know if you have any questions!
0
JohnBusiness Consultant (Owner)Commented:
QB Online is a workable alternative, but QB Desktop is a highly mature product if you wish to put in infrastructure for it
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Hardware Firewalls

From novice to tech pro — start learning today.