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.