Wednesday, July 22, 2015

Quickbooks H202 problems/thoughts

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:


  1. 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,
  2. 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.
  3. 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

No comments: