Solved

Multi-user networked Quickbooks issue with strange fix

Posted on 2014-09-29
6
895 Views
Last Modified: 2014-10-04
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.
0
Comment
Question by:kevinvw1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 26

Expert Comment

by:Fred Marshall
ID: 40351088
wired or wireless?
0
 

Author Comment

by:kevinvw1
ID: 40351133
All wired gigabit.

Thanks!
0
 
LVL 26

Accepted Solution

by:
Fred Marshall earned 500 total points
ID: 40351303
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
Does Powershell have you tied up in knots?

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

 

Author Comment

by:kevinvw1
ID: 40351472
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
 
LVL 26

Expert Comment

by:Fred Marshall
ID: 40352800
The diagnostic tool will fix firewall settings - amongst other things.
0
 

Author Closing Comment

by:kevinvw1
ID: 40361416
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

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

The reason that corporations and businesses use Windows servers is because it supports custom modifications to adapt to the business and what it needs. Most individual users won’t need such powerful options. Here I’ll explain how you can enable Wind…
I'm a big fan of Windows' offline folder caching and have used it on my laptops for over a decade.  One thing I don't like about it, however, is how difficult Microsoft has made it for the cache to be moved out of the Windows folder.  Here's how to …
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

631 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