OSX Server running Quickbooks, shared files disappear over Logmein Hamachi

I have a client running OSX server with Quickbooks server.  In the office the clients connect just fine.  There are a number of users who connect remotely via Logmein Hamachi (A subscription based VPN tool).

Those users using Hamachi have a terrible time, and I'm trying to find out why.

With QB for OSX you can only open files if they are 'shared' by the QB server... you don't browse to them like you do in Windows.  The server is sharing about 40QB files, and on the remote clients they often don't see any of them.  If we go onto the server and stop sharing on one file, and share it again, all of a sudden we'll see that shared file, or sometimes all, we can also access the file and performance is great.  If we wait 2-3 minutes, the shared list is gone and they can't work.

While this is happening I can still browse via finder and see all the files so we haven't truly lost connectivity.

I've verified Hamachi isn't 're-routing' through their servers (NAT problem indicated by blue dot in Hamachi interface).  I've verified there is no software firewall in play.

I did read a note from QB saying that the QB server needs to appear in the 'finder' under shared devices, and that is typically not the case.  If I connect to one of the shares then it will appear under shared devices, but QB files don't appear in the QB gui unless I stop and start sharing via the QB server.

I imagine this is't going to make sense to you unless you've actually messed with these products, so here goes nothing hoping that one of you has done this!!
LVL 8
ITDharamAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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:
I think you are telling me people have the QuickBooks client application on their remote PC and trying to run a QB database remotely. Is this true?  It is not good practice because you can damage the database.  You say a local connection works fine.

With QB for OSX you can only open files if they are 'shared' by the QB server  <-- That is also true in the Windows server world as well.

Please let me know if I am correct in my first statement.
0
ITDharamAuthor Commented:
Hi John,

You are correct, people are using QB on a local client accessing the DB across a VPN tunnel.

Understood about the possibility of corruption and I'm already prepping them that they might need to go to a QB enterprise on RDS, but for now we want to play this out.

If we do the stop share/share, the company file shows up, and accessing the file is smooth and reliable.  It is just getting the company files to show up reliably.
0
JohnBusiness Consultant (Owner)Commented:
You are correct, people are using QB on a local client accessing the DB across a VPN tunnel.

This is not a good practice because QuickBooks is a very chatty database. Using over VPN can easily corrupt files.

You need to use Terminal Server with QB on the Terminal Server or a desktop computer with QB that users can remote into.
0
Defend Against the Q2 Top Security Threats

Were you aware that overall malware worldwide was down a surprising 42% from Q1'18? Every quarter, the WatchGuard Threat Lab releases an Internet Security Report that analyzes the top threat trends impacting companies worldwide. Learn more by viewing our on-demand webinar today!

ITDharamAuthor Commented:
John, I hear you, and consider it noted.  Do you have any feedback regarding the question at hand?  Anybody else?
0
JohnBusiness Consultant (Owner)Commented:
I have seen databases damaged the way you are doing it and because QB is so chatty, I think the connection is being lost and that is why you no longer see the shared files until you restart.
0

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
ITDharamAuthor Commented:
I've also seen QB databases damaged doing everything on a server with remote desktop access...QB has problems.

Thanks for your time.
0
JohnBusiness Consultant (Owner)Commented:
Thanks.  QB is so chatty, it just does not run well this way.
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
VPN

From novice to tech pro — start learning today.