Learn how to use the Connectivity tool in QuickBooks Point of Sale.
The Connectivity tool helps you identify connectivity issues so you could address them properly. To fix these issues, follow the steps below.
- Issues that prevent Point of Sale from opening
- Network connectivity issues
- Not running or damaged QB Database Manager service
- Third-party firewall restrictions
- POS Warning 180063: Unable to start the database service
Note: Make sure to log in to your computer as a user with admin rights.
Restart Point of Sale
- On your keyboard, press the Windows+R to open the Run command.
- Type “services.msc” in the Run window, then press Enter.
- Right-click the QBPOS Database Manager (version), then select Restart.
Create a copy of the company file
Make sure to have a copy of your data before running the tool. This is different from making a backup copy of your company file.
- On your keyboard, press Windows+E to open the File Explorer.
- Browse to this location: C:\Users\Public\Documents\Intuit\QuickBooks Point of Sale (version).
- Right-click the Data folder, then select Copy.
- Select a location on your desktop where you want to save it, then select Paste.
Download and run the Test Connectivity Tool
- Download the QBPOS Test Connectivity Tool:
- Save the file to the following location:
- For 64-bit:C:\Program Files (x86)\Intuit\QuickBooks POS (version)
- After the download completes, select Run.
- The tool displays information about your computer and how it affects Point of Sale's ability to open:
QBPOS Install Type If this is your primary installation, this should display the Server Workstation. If it displays Client Workstation, Reinstall Point of Sale again as a server workstation.
Note: Version 12.0 will show a message in red that says it cannot find the installation folder so it will not display the installation type as expected.
QBPOS DB Service Status This should display Running. If not, close all programs, reboot your computer, and run the tool again.
Note: To return to the folder easily, right-click the Point of Sale icon and choose Open File Location.
TCP/IP Protocol This should display Enabled. If not, see the steps on to Fix TCP/IP Protocol below. Windows Firewall Status This should display Needed QBPOS Application exceptions defined in Windows Firewall in green. If it's in red, follow the steps on how to configure the Point of Sale firewall below. 3rd Party Firewall Status This displays Not detected if you don't have any other firewalls installed. If it displays detected, verify your internet security software isn't configured to block Point of Sale. See the Point of Sale firewall configuration steps below for a list of everything that needs to be allowed access for Point of Sale to open properly.
Note: This tool only detects firewalls from popular security companies. More obscure firewalls may not be detected here.
QBPOS Database Info The last Point of Sale file opened resides in this folder. If Startup Status displays anything other than Started, select Look Up Error Messages for steps to resolve startup issues. View Complete Database Log A highly technical log detailing Point of Sale's database activities. Useful when troubleshooting with a support representative or network technician. Ping Computers on Network Use this to be sure you can see other computers on the network. Best used on a client workstation to ensure it can access the server. Test Connect Use this to test the connection to your data file. Best used in a single computer environment, with a server workstation that's having trouble connecting to itself. If the connection fails, follow the steps on how to Configure the Point of Sale firewall below to be sure all needed files and folders are allowed through your internet security settings. Look Up Error Messages Use this to look up solutions to startup issues listed under Startup Status. Verify Again Use this to refresh the tool after making settings change on your computer.
- From the Windows Start button, search and select Control.
- Select Network and Sharing Center and Manage Network Connections.
- Right-click any enabled Local Area Connection, then select Properties.
- From the Networking tab, be sure Internet Protocols TCP/IPv6 and TCP/IPv4 are selected.
- If not selected, select them both and click OK.
- If already selected, clear the checkboxes and reselect them. Click OK.
- If Internet Protocol(TCP/IPv6) and (TCP/IPv4) is not listed, please consult a network or other computer technician to correct the issue
Refer to Firewall configuration for QuickBooks Point of Sale for detailed steps