Can’t Connect to Database
This article helps Webgility Desktop users resolve the “Can’t connect to database” error that may occur when connecting Webgility Desktop to QuickBooks Point of Sale (POS). It provides step-by-step troubleshooting instructions to verify system credentials, check POS configuration settings, and reset integration certificates. The goal is to help users successfully re-establish the connection so Webgility Desktop can access QuickBooks POS data for accurate syncing and transaction management.
Error Message:
Can't connect to database
Overview:
Webgility connects to QuickBooks POS using the database file. There could be multiple reasons if Webgility is not able to connect to QuickBooks POS. Here are a few things we can check to establish the connection between Webgility & QuickBooks POS.
Troubleshooting:
Note: Ensure QuickBooks POS is logged in with the SysAdmin user.
- In Webgility Desktop, go to Connections > Accounting/POS/ERP > Edit Connection, verify and update the correct details for the fields “Data file name”, “POS server computer name” & “POS version” & click Test QuickBooks POS Connection.
- If the issue persists then close the POS application on all the POS machines. On the POS Server machine go to Local Services, look for POS Database Manager and switch it to Network Service mode, and restart the services by right-clicking the POS Database Manager. Once done, launch POS again with the SysAdmin user & test the POS connection again from Webgility Software.
- If the issue persists, then in POS (on the same Webgility machine), go to File> Preferences> Company> Integrated Applications, remove all the certificates for the Webgility application and Scheduler, & click OK.
- Test the connection from Webgility Software and this should generate a connection certificate. You need to click on “Yes Always”, but in case if gives you a login popup for POS, please log in with the POS SysAdmin user (also make sure to check the box for remember me). It should give you a connection certificate, click on “Yes Always” and Save the configuration.
- Once connected successfully, you may click Save and close the window.