Quickbooks - All versions and QB database server manager issues

RFloyd30
RFloyd30 used Ask the Experts™
on
QuickBooks - all versions - DB Mgr issues and MultiUser mode plus simple access to a company file on a Server.

I've read article after article and  they all give the same solutions over and over - which of course are valid.  Open ports on firewall, exclude AV from scanning QB folders, share permissions, etc.
Although QB is a fantastic accounting program for the small business, its data structure and sharing is something else.  We have QB database mgr installed on servers ranging from Microsoft 2008/2012/2016 domain controllers with Microsoft DNS, dedicated QB member servers (No DNS), Windows 7/10 PCs with DB mgr, etc.  All experience the same issues over and over.
The problem:  Either cannot switch to MultiUser mode or cannot access a specific company file.

Our solutions, depending on which platform QB DB Mgr is installed on is basically to perform a "Scan" from the DB Mgr and once its complete, all is good.  Of course on DC's we have to stop DNS (or modify QB to look at other ports that don't conflict) or restart the QB service or just do the scan.  We do find that if we open the QB program on the DB Mgr server and open a company file, there is never an issue but that is not something you can leave because certain functions require QB to be in single user mode to perform.  Even if we disable any firewalls on the DB servers we still get issues.  Many times, on standalone servers, running the Scan to search for company files give a network error.  Most of the time we ignore this and QB functions in multiuser mode just fine until the next time a user cannot access their files and we have to "scan" again.

I'm asking is there a real solution to this or do we just know how and have to deal with it?  Its just a pain to have to remote into a client to reset the DB mgr on a server every week.

It sure would be nice for QB to use SQL like the express edition.  Things would be so much smoother but i'm sure with size limitations and cost of full SQL standard would cause different issues.

Thanks for any input if you have a good solution or teach us what we have been doing wrong all these years.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
We use QB at all our clients, newest version only. Yes, we have to scan for the database to use it. But then it works properly.

Are you running many versions of QB and if so, the newest database engine?

Is the QBFC service running and always starting

Author

Commented:
Thanks for comment.  Yes to all questions but usually one version.  I have cpa clients who use just about every version because of their clients which are not my IT clients.   But it’s the ones who use it for their business.   Get a call after a few days of no issue that someone cannot get Into specific company file and i have to remote in and run a scan to fix.  Or someone cannot switch to multi user mode.   It’s constant!!!
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
It may be the multiple versions of QB. We do not see this issue with one version.

Only open ONE version of QB at one time and one ledger with that version. Close out before opening another version of QB
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

Author

Commented:
Thanks for the input but not the issue.  Only the CPA firm runs multiple versions.  The companies that run QB as a part of the business are the ones i'm trying to address, which is always one version only.

I'm going to close the post in a day or two should there be no answer.  We have lived with this for a long time and it does not appear we are doing the setups incorrectly.   Was hoping to learn from another colleague who might have found a way to make it run smoother.

Thanks again for all the input.
Business Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018
Commented:
There is no other reason (after many, many years with QB) that Multi User does not work.

Author

Commented:
Thanks
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
I will keep watch on this for other possible solutions.

Author

Commented:
Thanks - i think i'm going to write a batch file to stop and restart services a few times during the week and setup a scheduled task to see if this keeps the calls down.  i'll update on its success or failure as well.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial