The QuickBooks File Doctor can test your network and help resolve netowork problems that affect QuickBooks. Each of the tests are described in the table below, including resources to help fix problems in each area.
Accessing QuickBooks files over a network requires QuickBooks Hosting turned on.
Important: (Ignore this warning if you are on the workstation computer).
The folder containing the company file must be shared to other users.
Determine if the QuickBooks PortFinder service in Windows is responsive.
Check if the Sybase Database Service is reachable and responsive.
Note: The Sybase Database service works directly with QuickBooks.
Turn on Hosting
The term hosting is used to describe the situation where the computer that is storing a company file (the host) allows other computers to access the file.
QuickBooks uses a service to manage company file access:
In Windows Control Panel, you can find this service in User Accounts, under Users for this computer. Look for the service that corresponds to your version of QuickBooks.
The following diagrams illustrate QuickBooks hosting modes.
QuickBooks requires 3 conditions be met before it can allow access to company files:
Once these 3 requirements are met, you can access the company file.
The hosting mode is set for each version of QuickBooks and for each computer. It is not set for the company file or the QuickBooks installation. When multiple versions of QuickBooks 2013 or later are used concurrently, the hosting mode settings for each version are independent.
There are 3 hosting modes: Not Hosting (also known as Hosting Off), Hosting Local Files only, and Hosting Local & Remote files.
Back to top
Share the folder in Windows
Note: The specific QBDataServiceUser for your version of QuickBooks also needs Full Control access to the folder containing your QuickBooks company file. Repeat step 4 to add the QBDataServiceUser for your version of QuickBooks if it is not already listed.
You may find the IPConfig tool useful in verifying the TCP/IP configuration of your computer. This often helps to troubleshoot problems using QuickBooks on a network.
The most common IPConfig commands are:
The ipconfig command is available in each version of windows:
For more information on IPConfig, enter ipconfig /? at the command prompt or visit support.microsoft.com. Microsoft.com is not an Intuit website.
Check to see if your firewall is blocking DNS requests
DNS query responses do not travel through a firewall in Windows Server 2003 (Microsoft KB article)
Configure your firewall
You may encounter errors if your firewall blocks Internet access needed for specific QuickBooks programs or files. Updating your firewall to the latest release may resolve the issue or you may need to manually configure your firewall software.
Grant the following files access through your firewall on ports 80, 8019, 56724, and 55358 through 55362 for both incoming and outgoing traffic:
Note: Intuit is unable to supply information for all of the several hundred firewall programs available today. The links in the following list lead to information for some of the more common firewalls. If your firewall is not listed here, refer to your software's documentation or the software publisher's web site.
Visit How to configure McAfee Personal Firewall to allow inbound connections on specific ports for detailed instructions provided by McAfee support to configure your firewall. Additional support options can be found at mcafee.com. You will be able to choose your type of business and the support option from the drop-down list.
Your search results will display knowledgebase article Creating a new firewall rule in Norton product. Follow the instructions provided by Norton technical support.
If you are using Windows 8 visit Open a port in Windows Firewall for Windows 8.
If you are using Windows 7 visit Open a port in Windows Firewall for Windows 7.
If you are using Windows Vista Open a port in Windows Firewall.
If you are using Terminal Services and have the Avast On-Access protection enabled visit How can I exclude a file from the on-access protection?. You will need to exclude your company file (.QBW file) and the files that need Internet access for your version that are listed in the top section of this document.
Grant the following files access through your firewall on ports 80, 8019, 56723, and 55353 through 55357 for both incoming and outgoing traffic:
Follow the instructions included in the QuickBooks file list above in combination with the instructions on the firewall maker’s web site (some common firewalls are listed below) to configure your firewall to allow Internet access to the QuickBooks files.
If you are using Terminal Services and have the Avast On-Access protection enabled visit How can I exclude a file from the on-access protection?. You will need to exclude your company file (.QBW file) and the files that need Internet access for your version that are listed in the top section of this document
Ping the server
Command-line utilities (MicroSoft KB article)