Friday, January 4, 2013

H202 error on Quickbooks caused by DNS/network settings mismatch

This problem caused me hours and hours of headache.

I wanted to move my Quickbooks Pro 2010 database host from one server to another.  I had done everything right on the new host as far as I could tell:

  1. install the database only option on the new server
  2. update the Quickbooks version on the server to the most recent version (R16 as of the installation time)
  3. open up the necessary ports in the firewall (8019, 55338)
  4. share out a folder with the appropriate sharing and file/folder permissions
  5. Open the quickbooks database server manager and scan the appropriate folder were QBW files are stored

In this case, I was getting H202 folders over and over again no matter what I did.  I went through many wrong paths, but I eventually found the problem to be the static IP address I had set.  Even though every network setting matched the settings that DHCP provided to workstations, it still did not work.

The only change I made to get Quickbooks hosting to work was give this new server (a Win 2008 32 bit server) a DHCP reservation instead of a static IP address.  I don't know if this added A record entry in my SBS 2008 server that was required or there was some other property (no WINS on my network) - but that was the sole change I made.

As for what I was seeing (in case this helps others).

This is what I'd get in the ND file when running the QB database server manager (without opening the files - note that engine name ends in _18 even though I'm on QB 2010 which means it should end in _20 . . . this is normal):

[NetConnect]
ServerIp=10.0.0.7
EngineName=QB_server7_18
ServerPort=10180
FilePath=E:\quickbooks\Test Company.QBW
ServerMode=1


This is what the ND file would change to when I had static DNS in place:


[NetConnect]
EngineName=QB_data_engine_20
FilePath=\\10.0.0.7\quickbooks\Test Company.QBW
ServerMode=2
FileConnectionGuid=cc8c20cf6bf5445bb1397c152c58645c


This is what the ND file changed to after being successfully opened once I had the DHCP reservation in place:

[NetConnect]
ServerIp=10.0.0.7
EngineName=QB_server7_20
ServerPort=55338
FilePath=E:\quickbooks\TestCompany.QBW
ServerMode=1
FileConnectionGuid=




12 comments:

Unknown said...

Get Expert advise and quick books support to manage and Grow your Business.
Contact on:-1800-935-0537

Tech Customer Support Number said...

I feel so elated to go through your blog. Every time I come across any of your blogs, I find myself in short of words to describe the uniqueness and the manner of representation. Amongst the various available websites and posts, I prefer a few and yours’ is one of them.
Here, I am giving a reference to the world-class, customer-friendly and outstanding technical service providers. Besides being highly inclined towards customers’ service, their team consists of members who are highly skilled and qualified through their work experience of years. Be sure to dial the QuickBooks Payroll Support Phone Number +1 833-228-2822.

Read more: QuickBooks Error 392

Quickbooks Expert said...

Nice & Informative Blog ! If you are facing QuickBooks Error H202 don’t hesitate to dial our toll free number 1-800-986-4607. We are providing best & instant support.

QuickBooks Enterprise Support said...

Thanks for sharing nyc information,
To fix QuickBooks Error C=1, you need to make sure that your information is protected during the fixation procedure of Quickbooks Error Code C=1.

QuickBooks Enterprise Support said...

Thanks for sharing informative information, get quick response, connect with Quickbooks Enterprises support at +1-888-485-0289, our team of experts will help you get rid of Quickbooks error H202 and others QuickBooks software issues. Call now!

Entire Help said...

On the off chance that you have likewise found any such mistake code, this article can be of incredible assistance to you. Thus, we have examined going to the How To Fix Quickbooks Error H202, it's potential causes, indications and barely any basic investigating techniques. So keep read on!

Asquare Cloud Hosting said...

This post is really very helpful article to resolve QuickBooks Scan Manager Not Working. but still if you have any issues related QuickBooks Error 9999 then connect with Asquare Cloud hosting at +1(855)-738-0359.

QuickBooks Tool Hub said...

Fix QuickBooks Error with the use of QuickBooks Tool Hub
Contact Us Email: info@mamfishsaves.com Phone No: 1-844-734-9204

Asquare Cloud Hosting said...

QuickBooks Error 1904 occurs because of the low maintenance of the PC. You can get solutions to troubleshoot the error code 1904 via the following web URL.

Fixing Error Code H202in QuickBooks | QuickBooks Error Code 6190 | QuickBooks Error 6094 | QuickBooks Error 6147 0

Accounting Experts said...

Resolve QuickBooks Issues and Errors with QuickBooks Tool Hub fix issue click here.
Resolve QuickBooks Issues and Errors with QuickBooks Tool Hub

How to Fix QuickBooks Error said...

Stuck with QuickBooks Error 6129 ? Check network settings, file permissions, and update QuickBooks. Quick fix: Reach out to QuickBooks support for assistance. Keep going, you'll solve it!

Axpert Accounting said...

Discover the causes and effective solutions for QuickBooks Error 1722 with our comprehensive guide. Learn step-by-step troubleshooting techniques, common pitfalls to avoid, and the impact on financial reporting. Stay informed with the latest updates and preventive measures to maintain a stable QuickBooks environment.