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);
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.
File servers can install QuickBooks as Server Only.
If QuickBooks is installed, set hosting to local files only by following these steps:
- Open QuickBooks.
- Press F2 to open the Product Information screen.
- 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:
- Click the Windows Start button and select Run.
- Enter services.msc in the Open field and click OK.
- Right-click QuickBooksDB19 (2009), QuickBooksDB18 (2008) or QuickBooksDB17 (2007); Select Stop.
- Right-click, select Start and Close the window.
- Display extensions for known file types.
- Right-click the Windows Start button and select Explore.
- Select the Tools menu and Folder Options.
- Click the View tab, clear the Hide extensions for known file types box.
- 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.
- Close Windows Explorer.
Delete the .ND file:
- Search for *.ND.
- In the Results window, right-click the .ND file and select Delete.
- Confirm deletion
Recreate the .ND file:
- Click the Windows Start button.
- Select All Programs, select QuickBooks > QuickBooks Database Server Manager.
- Click the Scan Folder tab.
- Click the Add Folder button, browse to the company file folder.
- Select the the company file, click the OK button.
- The path to the company file is in the Folders with QuickBooks company files field.
- Click Scan to start the scanning process.
- After the scan is complete, click Close.
Make sure client systems are not trying to host the company file.
- Open QuickBooks on each client computer.
- Press F2 to view the Product Information screen.
- In the lower left corner, below Local Server Information, Hosting should display Off.
If hosting is not Off, switch hosting modes:
- Login to QuickBooks as an Administrator.
- Select the File menu, Utilities > Stop Hosting Multi-user Access.
- When Do you want to stop hosting ...? appears. click Yes.
- When QuickBooks must close the company file and re-open...? appears, click Yes.
- Press F2 to view Product Information screen and make sure Hosting is Off.
By Mike Block
BlockTax QuickBooks is nationally known for QuickBooks, QuickBooks Add-ons, QuickBooks Terminal Server, and related user support and writing.
Voice of the Editor
Which isn’t completely true. I mean, occasionally I drop by when I manage to sneak out of the nonstop frat party over at Going Concern, but I’m mostly a wallflower over there. I’m happy to say that I’ve been given express permission (or explicit orders, if you like) to wander over here to AccountingWEB more often.
Why is that, you might ask? My job is to replace the irreplaceable Gail Perry as Editor-in-Chief. What does that mean? I don’t really know! I think it’ll be fun getting a feel for things, throwing in my own thoughts here and there, and listening to the discussions you’re having about the accounting profession.