I have a 3 user license for QuickBooks Enterprise. QuickBooks Desktop resides on two physical workstations and one virtual workstation. The QuickBooks company file resides on a mapped drive (Q:\QBDB) which each of the three workstations have a link to on their machines. QuickBooks is not installed on the actual file server where the company file is stored and end-users map to. The location of the company file is on a private server whose data, with other important data, is backed up nightly both on an off site.
Independently, each workstation can access the company file to work. But when two people try to access the company file at the same time we get errors (H202). I followed the instruction from this link ( https://quickbooks.intuit.com/learn-support/en-ca/account-management/how-do-i-make-it-so-users-open-... ) but nothing changed.
I have a proper domain environment consisting of file servers, workstations and storage servers. How can I get QuickBooks to accept my topology as-is without installing QuickBooks to storage server (where no programs reside) or having to dedicate a server/workstation to QuickBooks specifically?
It's 2021, surely QB can function in a healthy and proper domain environment?
In QuickBooks desktop including the Enterprise version, need a server manager to be able to work with multiple users at the same time.
This means you'll be asked to download, install, and configure a database server manager to accomplish such a goal. That said, let's consider checking how to set up QuickBooks Database Server Manager in QuickBooks Desktop for guidance.
Also, our Community Help Articles allow you to browse for references based on the product you installed while working with. In this reference, you're able to read through the steps commonly used to record your business transactions.
If you have any other questions, please let me know in the comments below. I'll be here to offer help. Stay safe!
I have a 3 user license for QuickBooks Enterprise. QuickBooks Desktop resides on two physical workstations and one virtual workstation. The QuickBooks company file resides on a mapped drive (Q:\QBDB) which each of the three workstations have a link to on their machines.
It is possible you are not running QBD in multiuser mode. Why did you create a virtual workstation to access the file?
I didn't say the company file was on a virtual machine. The company file is on a proper file server responsible for data protection and redundancy (backing up). The virtual workstation is needed for our remote accountants to login and access what they need. Quickbooks desktop is installed on that virtual workstation as it functions and fully qualified system our network. This is, as are their domain credentials, network security.
I prefer to keep data in a limited access and secured location that is backed up nightly and also stored off site. Putting the company file on any workstation isn't something I want to do. As stated previously, I'd have thought QB, particularly enterprise, would have matured enough since I last encountered it to function properly in a true client server environment.
I ended up loading the QBDBSM on a standalone Celeron Mini-PC just to determine its impact. After several hours, doing not much of anything, it appeared to be a low footprint TSR which, once configured, didn't need its GUI to function. That determined, I loaded it on my storage server. The issue is resolved. Still this sophomoric approach to something very simple that makes for an unnecessary point of compromise and/or failure that can and should be easily avoiding in this day. I've setup a few traps to monitor the QBBDSM to ensure its not broadcasting or permitting access to itself for any reason and also adjusted its service to restart itself on failure.
Thank you for your help