Overview:
This guide provides the causes and step-by-step instructions to resolve the "SQL Connection Disconnected" issue in Webgility Online.
Common Causes of SQL Disconnection:
Several factors can cause disconnection from an SQL database, including:
Network Connectivity Issues:
Problems with your network can disrupt communication between the database client and the server, resulting in disconnection.Server Overload:
If the SQL server is overwhelmed by too many requests, it may disconnect users to manage the load.Timeout:
If there’s inactivity between the client and server for a set time, the server may close the connection to conserve resources.Security Breach:
A potential security breach could prompt the database administrator to disconnect clients to protect sensitive data.Server Restart:
Disconnections can occur when the SQL server is restarted or shut down for maintenance.Database Maintenance:
During database maintenance tasks like backups or indexing, connections may be temporarily interrupted or disconnected.
Error Message:
When launching Webgility, you may see the following screen: "Select or Install SQL Server."
Steps to Resolve the SQL Connection Disconnected Error:
01. Open Services: Type "Services" in the Windows search bar and click Open.
02. Restart SQL Services:
Locate the service for SQL Server [Instance name for Webgility].
Right-click on SQL Server [Instance name for Webgility] and select Restart.
Repeat the process for SQL Server Browser by right-clicking and selecting Restart.
03. Log in to Webgility and Connect to SQL Server:
Once services are restarted, open Webgility and try to connect to your SQL server.
04. Select the SQL Server:
Click on Connect to an existing SQL Server.
Under Locate SQL Server, use the drop-down to select your existing SQL server, which should look like YourComputerName\DatabaseName.
The Computer Name will be the name of the main computer.
The Database Name is usually "UNIFY" or "WEBGILITY."
05. Authentication Mode:
Select Use SQL Server Authentication.
Enter the following credentials:
Username: sa
Password: Webgility2011 (note: "W" must be capitalized).Click Connect.
If SQL Server Is on Another Machine:
Click Browse more in the drop-down under Locate SQL Server.
Wait for the screen to refresh, and select the correct SQL instance once it appears.
Conclusion: By following these steps, you should be able to resolve the "SQL Connection Disconnected" error and reconnect to your SQL database in Webgility Online.
Need Further Assistance?
If you continue to experience issues or need additional support, feel free to reach out to Webgility Support for help.