Dealing with QuickBooks problems: H101, H202, H303, H505

If you open a QuickBooks file in multi-user mode you get this message:

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. (H202);

or

You are trying to work with a company file that is located on another computer, and that computer needs additional installation and setup. (H101, H303 and H505)

The causes of QuickBooks errors (QuickBooks problems) H101, H202, H303 and H505 are:

  • Hosting configuration settings are wrong.
  • A firewall is blocking communication in or out.
  • Damaged or wrong ND file.
  • QuickBooks cannot get the IP address of the company file host system.

If one computer has these QuickBooks errors (QuickBooks problems), you usually fix the H101, H202, H303, and H505 QuickBooks errors (QuickBooks problems) by getting a connection with TCP/IP settings. Do not use the steps below unless more than one computer has H101, H202, H303, and H505 QuickBooks errors (QuickBooks problems).

Make sure QuickBooks is on the server. QuickBooks 2007 and later have Server Only installs.

Click the Windows Start button, select All Programs > QuickBooks; If QuickBooks or QuickBooks DatabaseServer Manager is not installed see the install and multi-user setup instructions.

File servers can install QuickBooks as Server Only.

If QuickBooks is installed, set hosting to local files only by following these steps:

  1. Open QuickBooks.
  2. Press F2 to open the Product Information screen.
  3. In the lower left, below Local Server Information, Hosting should be local files only.

If QuickBooks Database Server Manager is installed, follow these steps to Restart the QuickBooks Database Server Manager:

  1. Click the Windows Start button and select Run.
  2. Enter services.msc in the Open field and click OK.
  3. Right-click QuickBooksDB19 (2009), QuickBooksDB18 (2008) or QuickBooksDB17 (2007); Select Stop.
  4. Right-click, select Start and Close the window.
  5. Display extensions for known file types.
  6. Right-click the Windows Start button and select Explore.
  7. Select the Tools menu and Folder Options.
  8. Click the View tab, clear the Hide extensions for known file types box.
  9. Click the View tab, select Show hidden files and folders, clear the Hide protected system operating files box ; Click Yes on the warning and OK.
  10. Close Windows Explorer.

Delete the .ND file:

  1. Search for *.ND.
  2. In the Results window, right-click the .ND file and select Delete.
  3. Confirm deletion

Recreate the .ND file:

  1. Click the Windows Start button.
  2. Select All Programs, select QuickBooks > QuickBooks Database Server Manager.
  3. Click the Scan Folder tab.
  4. Click the Add Folder button, browse to the company file folder.
  5. Select the the company file, click the OK button.
  6. The path to the company file is in the Folders with QuickBooks company files field.
  7. Click Scan to start the scanning process.
  8. After the scan is complete, click Close.

Make sure client systems are not trying to host the company file.

  1. Open QuickBooks on each client computer.
  2. Press F2 to view the Product Information screen.
  3. In the lower left corner, below Local Server Information, Hosting should display Off.

If hosting is not Off, switch hosting modes:

  1. Login to QuickBooks as an Administrator.
  2. Select the File menu, Utilities > Stop Hosting Multi-user Access.
  3. When Do you want to stop hosting ...? appears. click Yes.
  4. When QuickBooks must close the company file and re-open...? appears, click Yes.
  5. Press F2 to view Product Information screen and make sure Hosting is Off.

If errors persist, reestablish a connection through TCP/IP settings. For other errors see these instructions or contact Mike Block mblock@blocktax.com.

By Mike Block
BlockTax QuickBooks is nationally known for QuickBooks, QuickBooks Add-ons, QuickBooks Terminal Server, and related user support and writing.

You may like these other stories...

By Jason Bramwell San Francisco–based online accounting software provider Xero launched a free conversion platform on October 8 that will enable small businesses to migrate their Intuit QuickBooks data into Xero...
By Michael Callan, CPA, cofounder of Swizznet It wasn't that long ago that small and medium-size business (SMB) accounting software resided on a PC – and only on a PC. Today, with more than 1.3...
By Stacy KildalSo you have a client that wants to make the jump from QuickBooks Pro, Premier, Mac, or Enterprise? This is indeed exciting news, and I shall happily guide you through this process. Come with me, and let's...

Upcoming CPE Webinars

Jul 24
In this presentation Excel expert David Ringstrom, CPA revisits the Excel feature you should be using, but probably aren't. The Table feature offers the ability to both boost the integrity of your spreadsheets, but reduce maintenance as well.
Jul 31
In this session Excel expert David Ringstrom helps beginners get up to speed in Microsoft Excel. However, even experienced Excel users will learn some new tricks, particularly when David discusses under-utilized aspects of Excel.
Aug 5
This webcast will focus on accounting and disclosure policies for various types of consolidations and business combinations.