If you are using QuickBooks in multi-user mode, such as the 3-user QuickBooks 2019 Premier license (available on Amazon – http://amzn.to/301vV7u), the QuickBooks Database Server Manager now assigns dynamic ports. To find the port, open QuickBooks Database Server Manager, click on the Port Monitor tab, look for the QuickBooks Desktop 2019 line.

You will then need to add the following exceptions to your computer firewall solution.

QuickBooks Desktop 2019: 8019, XXXXX. (XXXXX is the assigned port number found in QuickBooks Database Server Manager)

Previous editions used the following ports:

QuickBooks Desktop 2018: 8019, 56728, 55378-55382
QuickBooks Desktop 2017: 8019, 56727, 55373-55377
QuickBooks Desktop 2016: 8019, 56726, 55368-55372

When opening a company file across a network on a machine running a QuickBooks 2008 Database Server, the user was unable to open the file in Multi-User Mode.  The error was H202  – “You are trying to work with a company file that is located on another computer and this copy of QuickBooks cannot reach the server on that computer”.

After confirming read/write access to the network drive, confirming the appropriate firewall exceptions for the executables, deleting the *.ND files in the share, and then rescanning with the QuickBooks Database Server Manager to create new *.ND files, we still could not open the company file.

It turns out the mapped drive script uses the FQDN (eg, \\quickbooksDB.corp.companyname.com\qb$) to access the share.  Once the script mapping was changed to just use the hostname (eg, \\quickbooksDB\qb$), the user could successfully open the company file.