Home | Site Map | Cisco How ToNet How To | Wireless |Search | Forums | Services | Donations | Careers | About Us | Contact Us|

Error: can't communicate with company file due to firewall

Network Sharing , TCP/IP, Internet, Wireless, Exchange, IIS, ISA and Print

Error: can't communicate with company file due to firewall

Postby blin » Mon Dec 05, 2016 4:53 pm

Q: When running QuickBooks 2016 on multiple computers, we keep getting QuickBooks Error: can't communicate with company file due to firewall on the remote computer. I have follow this article: "Error H101, H202, H303, or H505: when opening your company file ", but can't fix it.

Quoted:
When you open a company file in multi-user mode, you see an error:

•You're trying to work with a company file located on another computer, and this copy of QuickBooks can't reach the server on that computer (H202).
•It appears that the QuickBooks software on computer [server name] is set up to allow shared connections to the company file, but the QuickBooks software on your computer is unable to communicate with it (H202).
•You're trying to work with a company file located on another computer, and that computer needs additional installation and setup. (H101, H303, and H505).


Note: Intuit does not support firewall or anti-virus programs. You may need to consult the program provider for assistance with installing and setting up your program.


Why is this happening

QuickBooks Desktop is trying to establish a connection to the company file and can't communicate with the server (computer hosting the QuickBooks files).

Several issues can cause the following:
• Hosting configuration settings are incorrect - Another computer might have hosting turned on. Only the server (where the file is saved) should have hosting turned on.
• QB firewall ports are not set properly - Firewall is blocking incoming/outgoing communication to the company file.
• The .ND file is damaged or incorrect - The .ND file is a configuration file that allows QuickBooks to access a company file in a network. A damaged .ND file may prevent QuickBooks Desktop from accessing files over the network.
• QuickBooks can't obtain the IP address of the host computer - QuickBooks Database Server Manager might be using a different/bad IP address.
• DNS settings are incorrect - Workstations are configured to open the file through the hosts’ Full Qualified Domain Name (ex. computername.domain.com).
• QuickBooks services are not started - QuickBooksDBXX or QBCFMonitor services are not running and should be started automatically.


How to fix it

Resolve QuickBooks Desktop errors: H101, H202, H303, and H505

Intuit recommends several solutions for resolving errors. The first solution may solve your problem, or you may need to try all of them to resolve the issue. For best results, perform the solutions in the order shown.

Solution 1: Download and use the QuickBooks File Doctor
Download and run the QuickBooks File Doctor on the server and any workstation getting an H-series error. QuickBooks File Doctor will attempt to automatically resolve the multi-user error.
If you still see the error, try the next solution.

Solution 2: Check hosting and services

1. Verify hosting

In a multi-user environment, hosting should only be enabled on the hosting computer (server).
1.On each workstation (not the server or hosting computer), open QuickBooks and choose File > Utilities.
2.If you see Host Multi-User Access on the list, this computer is not hosting the company file and you can go to the next computer. Note: Don't change anything if you see Host Multi User Access at your workstation.
Host multi-user access
3.If you see Stop Hosting Multi-User Access, select that option.


a.Click Yes to confirm.
b.In the Company File Must Be Closed window, click Yes.
4.Repeat steps 1-3 on each computer.


2. Verify QuickBooks services

When working with QuickBooks Desktop in a multi-user mode, QuickBooks services need to be running on the server computer.
1.Make sure the QuickBooksDBXX (XX represents the year of QuickBooks Desktop) and QBCFMonitorService services are started. •Click the Windows Start button.
•Press the Windows key + R to bring up the run box.
•Type services.msc and press Enter.

2.In the services window, scroll down and look for the QuickBooksDBXX service. Note: XX represents the year of QuickBooks Desktop you are troubleshooting.
◾ If you do not see the QuickBooksDBXX service:
◾If you only use the Database Server Manager (the entire program itself is not run on the server) make sure that the Database Server Manager is installed on the server. Note: Each year of QuickBooks Desktop you have on the workstations will need to have its Database Server Manager installed to use multi-user mode.
◾If you run the entire program on the server, open QuickBooks, go to File-> Utilities-> and make sure hosting is enabled (it should say Stop Hosting Multi User access. If it says Host Multi User mode, click it to enable hosting on the server).


3.Double-click the QuickBooksDBXX service and make sure the Startup Type is set to Automatic and service status is Running (Started in Windows 7).



4.Click the Recovery tab.


5.Click the drop-down menu for First failure and select Restart the Service. This will automatically restart the QuickBooksDB service if it fails. Do the same for Second failure and Subsequent failures:



6.Click OK to save the changes.

7.Repeat steps 1-6 above for the QBCFMonitorService.
8.Open QuickBooks in multi-user mode on each affected workstation. If the issue persists, try to make sure the QuickBooksDBXX service is a member of the administrator group and has the appropriate permissions.

Windows Server 2012 Essentials R2

Windows Server 2012 Essentials R2 requires that programs be authenticated every time the system boots up. QuickBooks will not pass this authentication. When using that system as a QuickBooks file server, a few steps need to be taken after every reboot or an H202 error will occur.

The following steps should only be done when running Windows 2012 Server Essentials
1.Stop the Base Filtering Engine Service. a.On your keyboard, press Windows + R to open the Run window.
b.In the open field, enter services.msc and press Enter.
c.Right-click the Base Filtering Engine Service.
d.Choose Stop. (If an error occurs, dismiss the error and stop the service again)

2.Scan the QuickBooks File Directory with the QuickBooks Database Server Manager. a. Start > All Programs > QuickBooks > QuickBooks Database Server Manager
b.Click the Scan folders tab.
c.Click Add folder (if no folders are present). Otherwise, highlight the folder with the files and click Scan.
d.When the process is complete, close the Database Server Manager

3.Start the Base Filtering Engine Service. a.On your keyboard, press Windows + R to open the Run window.
b.In the open field, enter services.msc and press Enter.
c.Right-click the Base Filtering Engine Service.
d.Choose Start. (If an error occurs, dismiss the error and stop the service again)

4.If this did not resolve your issue, follow the steps in the Multi-User access changes in QuickBooks 2015 and later (how to enable alternate setup/NAS drive) article.



Solution 3: Open the network ports QuickBooks uses to transmit data

Configure Firewall

IMPORTANT (Windows 8): AVG Antivirus 2013 users: In depth research by our engineering team has determined that a conflict exists between QuickBooks and AVG AntiVirus 2013 on Windows 8. The conflict has been isolated to AVG, and if you are using AVG AntiVirus 2013 or AVG Antivirus 2013 Free on Windows 8 and have an H202 error, you will need to uninstall the AVG program and enable Windows Defender (built into Windows 8). You will need to contact AVG support if you have any questions or wish to keep the AVG 2013 software.

Perform the following on each computer:
1.Access Windows Firewall Settings ◾ Windows 10 1.Right click the windows icon and select Control Panel.
2.Type "Firewall" in the search bar and press Enter.
3.Select Windows Firewall and select Advanced settings.

◾ Windows 8 1.Hover the mouse in the upper or lower right-hand corners and select Settings.
2.Click on Control Panel and choose Windows Firewall.
3.On the left, click on Advanced Settings.

◾ For Windows Vista/Windows 7/Windows Server 2008 1.Click the Start menu and enter firewall.
2.Click on Windows Firewall with Advanced Security.




2.On the left, right-click on Outbound Rules, and choose New Rule ◾ Note (Windows Vista/Windows 7/Windows Server 2008): It's a little tricky, you have to left-click Outbound Rules first to highlight it, then right-click on it.



3.Choose Ports and click Next.
4.Select TCP and in the specific local ports box, enter in the following ports: ◾ QuickBooks Desktop 2017: 8019, 56727, 55373-55377
◾ QuickBooks Desktop 2016: 8019, 56726, 55368-55372
◾ QuickBooks Desktop 2015: 8019, 56725, 55363-55367
◾ QuickBooks Desktop 2014: 8019, 56724, 55358-55362



5.Click Next and select Allow the Connection.
6.Click Next to enter a name in the name field (for example, "QuickBooks ports" ) and click Finish.
7.Repeat steps 1-5 for the Inbound Rules.
8.Open QuickBooks in multi-user mode. ◾If you have a third party antivirus/firewall program, you may need to configure any other firewall or antivirus software.
◾ Note: For a temporary solution, you may disable the anti-virus/firewall program to identify it as a problem and make sure to re-enable it when you're done with the test. If the error persists, continue to step 3 (Ping the Server Computer).


Check UNC vs Mapped Drive (file path troubleshooting)

Important: These steps are highly technical in nature and may be best performed by a qualified IT professional present. The scope of this test is to see if QuickBooks can reach the server from the workstation(s).


Ensure Network Discovery is turned on before performing the following steps:


To turn on Network Discovery: 1.Open Control Panel, click System and Security, and then click Windows Firewall.
2.In the left pane, click Allow an app or feature through Windows Firewall (if you are running Windows Server 2012).
3.Click Change Settings.
4.Select Network Discovery, and then click OK.


1.Identify the name of your server if you don't already know it. 1.Open a Windows Command Prompt: ◾ Windows 10 and 8: Press the Windows Key + R to open a run command and type CMD and press the Enter key
◾ Windows Vista/Windows 7/Windows Server 2008: Click the Windows Start button, enter cmd and press the Enter key.

2.Enter ipconfig /all, and press the Enter key.
3.Make note of the Host Name.



2.Enter ping [servername], and press the Enter key. For Example: If your server name is Server1, you would enter ping Server1 and press the Enter key.
3.
4.You should see a reply for each packet with none being lost. Important: If you see packet loss or a slow reply, your network should be diagnosed by a qualified IT professional.
5.If using a mapped drive to connect to your company file on the server, bypass the mapped drive by navigating to the server shared folder via UNC (Universal Naming Convention) path from the workstation computer (ex: \\server\QBData\). ◾If the path to your company file is on your network and begins with a drive letter, it's a mapped drive.



6.Use the UNC path, found in the title bar, to navigate to your company file within QuickBooks.



Solution 4: Add your server to the Windows hosts file

It may be necessary to edit the Windows hosts file.

Solution 5: Create a new folder for your company file
1.On the hosting computer, create a new folder, share it, and set Windows access permissions to share company files. ◦ Note: If you do not have access to the QuickBooks file server, you will need to contact your IT professional.

2. Copy the .qbw file to the new folder.
3.Open your company file in multi-user mode.
How to Configure and Troubleshoot Cisco
http://www.howtocisco.com

Tablet and Smartphone Setup Guide
http://www.quicksetupguide.com
blin
Site Admin
 
Posts: 3605
Joined: Wed Dec 31, 1969 7:00 pm
Location: Chicago, USA

Re: Error: can't communicate with company file due to firewall

Postby blin » Mon Dec 05, 2016 4:55 pm

We had the similar case. After we upgrade to Windows 10, we keep getting the same error. If the host computer close quickbook, then the other computers can access it without any issues. Or restart the host computer.
How to Configure and Troubleshoot Cisco
http://www.howtocisco.com

Tablet and Smartphone Setup Guide
http://www.quicksetupguide.com
blin
Site Admin
 
Posts: 3605
Joined: Wed Dec 31, 1969 7:00 pm
Location: Chicago, USA

Re: Error: can't communicate with company file due to firewall

Postby chicagotech » Mon Apr 17, 2017 4:29 pm

If you have multiple computers using the same software, please make sure all of them are in the same version.
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on http://www.HowToNetworking.com
chicagotech
Site Admin
 
Posts: 6704
Joined: Mon Nov 27, 2006 1:24 pm
Location: Chicago USA


Return to Networking

Your Ad Here

Who is online

Users browsing this forum: Exabot [Bot] and 6 guests