How to Fix Webgility Login Errors Caused by Database and SSL Issues
This article helps Webgility Desktop users troubleshoot multiple login errors in Webgility Desktop application, specifically those related to database query failures and SSL issues. It provides step-by-step guidance to identify the causes and resolve these errors to restore successful access.
Overview
This article details troubleshooting steps for resolving multiple login errors encountered in Webgility, focusing on database query failures and SSL-related issues.
Common Causes of Webgility Login Errors
- Database connectivity issues (e.g., failed queries, timeouts)
- SSL configuration problems (certificate mismatches, expired/invalid certificates)
- Outdated Webgility application versions
- Network disruptions affecting local or remote database and Webgility connections
Step-by-Step Troubleshooting
1. Verify Webgility Application Version
- Confirm the installed Webgility version matches the latest release.
- If outdated, take a backup and update the application.
2. Check Database Services and Query Status
- Confirm that the underlying database service (typically SQL Server or MySQL) is running under services.msc.
- Restart database services and place it on the network if issues persist.
3. Run Webgility Database Utilities
- Run UnifyDBUpgrade and UnifyDBUtility from the application's install directory(C Drive > Webgility > Unify Enterprises).
4. Inspect Network and Firewall Settings
- Ensure ports required by Webgility and its database backend are open on all relevant firewalls.
- Test local network connectivity between the Webgility host and the database server.
- Temporarily disable security software to rule out external blocking.