How to solve SQL Database Connection Issues in Webgility Desktop
This article helps Webgility Desktop users troubleshoot SQL connection errors during login. It covers issues such as the SQL Server service not running, port conflicts or firewall restrictions, invalid login credentials or permissions, and temporary network or system instability.
This guide outlines the troubleshooting steps for resolving SQL connection errors when logging into Webgility Desktop. It includes diagnostics, service checks, and corrective actions that you can follow before escalating the issue.
Common Causes of SQL Connection Errors
-
SQL Server service is not running
-
Port conflicts or firewall restrictions
-
Invalid login credentials or permission issues
-
Temporary network or system instability
Step-by-Step Troubleshooting
1. Confirm SQL Services Are Running
-
Open the Services window (
services.msc). -
Locate the service:
SQL Server (WEBGILITY). -
Ensure the Status is set to Running.
-
If not running, right-click and select Start or Restart.
2. Confirm SQL and Browser Services
-
Open Services (
services.msc). -
Locate the following services:
-
SQL Server (WEBGILITY) -
SQL Server Browser
-
-
Right-click each service and select Properties.
-
Go to the Log On tab:
-
Click Browse, search for Network Service.
-
Remove any password fields (if populated).
-
-
Click Apply, then OK.
-
Restart both services.
3. Enable TCP/IP and Named Pipes
-
Open SQL Server Configuration Manager.
-
Navigate to:
SQL Server Network Configuration > Protocols for WEBGILITY -
Ensure TCP/IP and Named Pipes are enabled.
-
Right-click and select Enable, if necessary.
-
Restart the SQL Server (WEBGILITY) service to apply changes.
4. Configure Firewall Rules
-
Navigate to:
C:\Webgility\UnifyEnterprise -
Locate the file:
wgFirewall.exe -
Right-click and choose Run as Administrator.
-
This tool will automatically configure required firewall rules for SQL communication.