Multi-user networked Quickbooks issue with strange fix

I have been fighting a Quickbooks issue for months and I think I may have finally found the solution.
I am posting this in hopes of possibly helping someone else and of maybe getting some feedback on why this fix worked.

Issue - Quickbooks Pro randomly refuses to let users open files.  
Sometimes the files won't open unless no other user is in the file (even though file is open in 'multi-user' mode).
Sometimes the user can open in single user, but can't switch to multi-user.
Sometimes only solution was to reboot the server.
Problems varied from workstation to workstation.

Environment -
Windows 2012 server, LAN, domain.
Quickbooks Pro 2013 installed on server.
Quickbooks Database Management Server running on server
Quickbooks data files stored on server hard drive.
Workstations - Windows 7 and Windows 8.1.
All firewall and anti-virus settings appear to be correct and allowing proper ports and apps to run.

Notes - Normally in a multi-user server install environment such as this, you don't even need to install full Quickbooks on the server.  
You can just install the Quickbooks Database Management Server.
I started with this configuration, but I was having so many issues, I went ahead and installed the full Quickbooks app on the server to help me deal with enabling/disabling multi-user hosting.

The Fix -

What seemed to finally fix all the issues was to simply open up the Quickbooks application on the server and leave the app running.  No Quickbooks data file is open on the server, just the app is open.
The Quickbooks Database Management Server is still running as well.


Can anyone think of any reason why this fix would work?

Thanks, Kevin.
kevinvw1Asked:
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.

Fred MarshallPrincipalCommented:
wired or wireless?
0
kevinvw1Author Commented:
All wired gigabit.

Thanks!
0
Fred MarshallPrincipalCommented:
OK.  Well, it's fairly well proven that QuickBooks will not work reliably on wireless networks and what you describe is close enough to what happens.  The client machines generate an error that says the file can't be accessed.

What does the QuickBooks Network Diagnostic Tool software say when you run it?
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
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

kevinvw1Author Commented:
hmmm, good question about the diagnostic tool.  I haven't had the issue in over a week now (since I am now leaving QB open on the server).
I was starting to think I had a network wiring issue, but since leaving QB open seems to have fixed the issue, I don't think wiring is at play.
0
Fred MarshallPrincipalCommented:
The diagnostic tool will fix firewall settings - amongst other things.
0
kevinvw1Author Commented:
Thanks for the input.   It is a bit puzzling why leaving the QB app open on the server fixes the issues, but what the heck, it works.

Thanks,

Kevin.
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
QuickBooks

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.