Hosting your QuickBooks company file on a server adds complexity and often leads to Error 6123. Here's how to host correctly:
1. Dutch Server vs. Workstation Hosting Decide if your server will be a dedicated file host. Install QuickBooks Database Server Manager (QBDBMgrN.exe) from your QuickBooks installer on the server. You should not open the company file in the full QuickBooks software on the server; only host it.
2. Configure Firewall on Server Make sure QuickBooks and QBDBMgrN.exe are allowed through Windows Defender Firewall or any third-party firewalls.
3. Shared Folder Permissions For the folder containing the .QBW file: - In the Sharing tab, share with Everyone (or a specific user) and give Read/Write access. - In the Security tab, add user accounts and “SYSTEM” with Full Control.
4. Static IP/Host Name Assign a static IP to your server and map client workstations to \ServerName\QBFolder or \192.168.1.100\QBFolder.
5. Rename .ND/.TLG Files After moving files or updating QuickBooks on the server, rename the existing .ND and .TLG files associated with the company file.
6. Schedule Nightly Server Reboots Rebooting nightly clears any hung services that might cause multi-user lock conflicts and lead to Error 6123.
7. Log and Report If clients report Error 6123, record the time, user, client version, and any recent changes on the server. Upload log files (Intuit log) if necessary. Share snippets here so the community can help you understand them.
Following these best practices helps reduce host-side misconfigurations that lead to Error 6123 in your shared environment.
Read More:https://qbookassist.com/quickbooks-error-6123/
|