We do encounter challenges during networking and configuration of QuickBooks data file for multi-user access, but the problem of wireless networking not strong enough or the firewall on the workstation preventing the user from accessing central data are more often and prominent.
Today, we were faced with an unusual firewall security challenge at a client’s office (a fast-growing private school with multiple locations). They use the Pro version of QuickBooks, which had already been cut off from automatic updates, and they requested an upgrade to Premier – a better version that accommodates a higher volume of transactions with up to five (5) allowable users.
After configuration of a two (2) user system and a setup of the company file on a host server for shared access, one of the systems blocked the file from accessing QuickBooks with the below summarized messages:
Request For Our Accounting Software ServiceFor over 5 years, we have implemented QuickBooks and Sage 50 for several companies under Retail, Manufacturing, Oil & Gas, Real Estate & Construction, Travels, Hospitality,Legal, Co-operatives, NGOs, Financial & Service Sectors.
- Mbaire Services Nigeria Ltd(Construction)
- Chisco Transport Limited(Transport)
- Lounge38(Hotel and Bars)
- CTRL System Technologies Limited(Procurements)
- Aristokrat 360 Limited(Creative & Media Agency)
- Alpha Pharmacy (Health Care & Supermarket)
- Ericsson Nigeria Multipurpose Co-operative Society (Co-operatives)
- Fastanet Limited (ICT and Security)
- Britanic Maritime (Maritime Service)
- CEO Business Limited (Salary Advance, Credit Finance and Loan)
- OneHealth Pharmacy (Health Care)
- Widdi Pharmacy (Health Care)
- Olpharm Pharmacy (Health Care & Distributor)
- Hawkes Legal(Legal)
- Kantessa Limited(Fashion Store)
- OPI Nigeria International Limited (Oil & Gas Servicing)
- Zenilum Company Limited (Oil & Gas Servicing)
- Extol Security Services Limited (Security and Guard Services)
- Lilygate Hotel(Hospitality)
- Benstel Nigeria Limited(Bottle Water Production & Distribution)
- Paraclete Nigeria Limited (Bottle Water Production & Distribution)
- Lakia Construction Limited (Real Estate Development)
- Josien Holdings Limited(Distribution)
- Aisha Buhari Foundation (Futured Assured)(NGO)
- Doheney HR Services(HR)
- Insights Limited(Health Consultant)
- Biddel Oil & Gas Limited (Oil & Gas)
- System Intelligenz Limited(Contractor)
- MagTech Information Security (IT)
- Infusion Cakes Nigeria (Bakery)
- SCERA Nigeria (NGO)
- M.D School (Private School)
- Travel Options (Travels)
- Logos Travel Support & Solutions Ltd (Travels)
- Melcurt Nigeria Limited (Oil and Gas Engineering and Pipeline Construction)
- Starlight Nigeria (Retail)
- Temple Private School (Education)
- Value Mart Supermarket (Retail)
- Transweb Bureau De Change (Financial Service)
- Vektro Food Limited (Manufacturing & Retails)
- Orient Petroleum PLC (Oil & Gas)
- Plus More
“The computer (host) server is configured to allow shared access but your system can’t open the file. This may be due to firewall configuration on your network.”
If you encounter issues like this during QuickBooks Desktop configuration, it means that your firewall blocks the networking access needed for the multiuser environment to work.
With our technical team on ground, we eventually configured the firewall security to allow QuickBooks desktop.
Here is how we manually fixed the issues:
Please note that we deployed QuickBooks Premier 2018 with the below steps. You can still replicate these steps for other versions like 2016, 2017, 2019 to current year’s releases.
Add Firewall port exception for QuickBooks:
If you’ll be using multiple year versions of QuickBooks Desktop, you need to perform the following for each year’s version.
- From Windows OS, search bar open Windows Firewall
- Select Advanced Settings
- Right-click Inbound Rules. Then select New Rule
- Select Port. Then select Next
- Make sure TCP is selected. Enter the specific ports needed for your QuickBooks year version. Then select Next.
QuickBooks Desktop 2019: 8019, XXXXX. (XXXXX is the assigned port number found in QuickBooks Database Server Manager)
QuickBooks Desktop 2018: 8019, 56728, 55378-55382
QuickBooks Desktop 2017: 8019, 56727, 55373-55377
QuickBooks Desktop 2016: 8019, 56726, 55368-55372
- Select Allow the Connection, select Next.
- If prompted, make sure all profiles are marked. Select Next.
- Give the rule a name, such as QBPorts(year). Select Finish.
- Repeat the steps above for the Outbound Rules (for step 3, choose Outbound Rules instead of Inbound). Try opening QuickBooks Desktop again in multi-user mode or over your network to see if the issue has been resolved.
If you’re experiencing errors or problems with connectivity, make exceptions to programs QuickBooks uses in Windows Firewall.
Create Firewall exceptions for QuickBooks programs:
QuickBooks uses executable files to perform various functions. See the ‘Configure your anti-virus or firewall programs’ section for a list of executable files. Then perform the following steps for each file.
- From the Windows search bar, enter then open Windows Firewall.
- Select Advanced Settings.
- Right-click Inbound Rules. Then select New Rule.
- Select Program. Then select Next.
- Select This Program Path. Select Browse.
- Navigate the file location. Select Next.
- Select Allow the Connection. Select Next.
- If prompted, make sure all profiles are marked. Select Next.
- Give the rule a name. Select Finish.
- Repeat the steps above for the Outbound Rules (for step 3, choose Outbound Rules instead of Inbound).
Restart the computer and reconnect to the server or host computer for multi-user access; this should work.
If you need help on how to configure your system’s firewall security during QuickBooks desktop setup for multiuser, do connect with our client support Centre:
Recommended QuickBooks Software With Genuine License Details, It's One-Off:
Order Now, Call 08105090001, 08084219399 or mail at firstname.lastname@example.org
QuickBooks Premier – 1 UserView Price Offers
QuickBooks Premier – 3 UsersView Price Offers
QuickBooks Premier – 4 UsersView Price Offers
QuickBooks Premier – 5 UsersView Price Offers
QuickBooks Premier – 2 UserView Price Offers
QuickBooks Pro – 1 UserView Price Offers
QuickBooks Pro – 2 UsersView Price Offers
QuickBooks Pro – 3 UsersView Price Offers