I can't explain how I have so many problems at one client with Quickbooks server/client issue - whereas I have other clients with the same setup with no problems.
After spending 8 hours on it yesterday, here are some more things to troubleshoot/look at:
- On the Quickbooks host, ping the host itself with NETBIOS name (meaning if the host is machine X, open a DOS prompt on machine X and ping X). If you get anything other than an IPv4 address in the reply, make an entry for the QB host in the HOSTS file,
- On the Quickbooks host, telnet to each of the ports that should be open to make sure you know what should be open (telnet NETBIOSNAME 8019). List of ports is below.
- On a Quickbooks client, telnet to each of the working ports to make sure they aare working properly (and if not - adjust firewall settings as appropriate).
And even with the above in place, you *still* might have trouble. I had a Windows 7 physical machine set up optimally that would just not work right. Whenever a client tried to convert the QBW file to multi-user mode, Quickbooks would give an H202 message. I also had a Windows 2008 32 bit Hyper-V VM machine that was optimally configured as well. I would also get an H202 error when trying to put a client (logged in as admin) in multi-user mode. Every possible thing I could see was optimal.
I ended up creating a new Windows 2008 R2 VM - configured no differently than the two above machines in any meaningful way - that worked. IP address was given through a DHCP reservation. There was a HOSTS file entry on it. I made the firewall adjustments. I shared out the folder that had the QBW file with appropriate permissions. I ran the QB database server tool and scanned the appropriate directory. The initial ND file looked no different than the ND file from the above two machines (Win 7 and Win 2008 RTM 32 bit). I can't explain it, but at 5 am - I was able to get a reproducible successful state.
Quickbooks ports that need to be open in the firewall:
QuickBooks 2015: 8019, 56725, 55363-55367
QuickBooks 2014: 8019, 56724, 55358-55362
QuickBooks 2013: 8019, 56723, 55353-55357
QuickBooks 2012: 8019, 56722, 55348-55352
QuickBooks 2011: 8019, 56721, 55343-55347
QuickBooks 2010: 8019, 56720, 55338-55342
Initial ND file when you first create it:
// This is QuickBooks configuration File. It exists while users are connected
// to a company file. Do not delete this file yourself. QuickBooks may not
// operate correctly if you manually delete this file.
[NetConnect]
ServerIp=10.0.0.170
EngineName=QB_qbserver_18
ServerPort=10180
FilePath=C:\QB\TestCompany, LLC.QBW
ServerMode=1
FILECONNECTIONGUID=
Final ND after it is successfully used:
//This is QuickBooks configuration File. It exists while users are connected
// to a company file. Do not delete this file yourself. QuickBooks may not
// operate correctly IF you manually delete this file.
[NetConnect]
ServerIp=10.0.0.170
EngineName=QB_QBSERVER_23
ServerPort=55353
FilePath=C:\QB\TestCompany, LLC.QBW
ServerMode=1
FileConnectionGuid=26cf2cf47dcf46e2b8baded2b92bad14