Skip to content
  • There are no suggestions because the search field is empty.

How to Troubleshoot SQL Connection and Restore Issues in Webgility Desktop

This article helps Webgility Desktop users in addressing Webgility Desktop connection issues with SQL databases. It focuses on common causes such as SQL installation integrity problems and backup restoration challenges, offering step-by-step guidance to restore stable connectivity.

This article provides a support playbook for resolving Webgility Desktop software connection issues to SQL databases, particularly when related to SQL installation integrity and backup restoration.

Common Causes of SQL Disconnection:

Several factors can cause disconnection from an SQL database, including:

  1. Network Connectivity Issues:
    ​    Problems with your network can disrupt communication between the database client and the server, resulting in disconnection.

  2. Server Overload:
    ​    If the SQL server is overwhelmed by too many requests, it may disconnect users to manage the load.

  3. Timeout:
    ​    If there’s inactivity between the client and server for a set time, the server may close the connection to conserve resources.

  4. Security Breach:
    ​    A potential security breach could prompt the database administrator to disconnect clients to protect sensitive data.

  5. Server Restart:
    ​    Disconnections can occur when the SQL server is restarted or shut down for maintenance.

  6. Database Maintenance:
    ​    During database maintenance tasks like backups or indexing, connections may be temporarily interrupted or disconnected.

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.

      • Select Use SQL Server Authentication.

      • Enter the following credentials:
        ​Username: sa
        ​Password: Webgility2011 (note: "W" must be capitalized).

      • Click Connect.

      Steps To Take Backup:

      • In Webgility Desktop navigate to System then click on Backup.
      • Select the Webgility folder for the .bak file to store the backup, navigation path is C:\Webgility.

      How to Restore a Backup

      • Before restoring, make sure the backup file is in C:\Webgility
      • Login into Webgility Desktop, go to the System Tab click on Backups and go to Restore.
      • Once the backup restoration is completed Webgility Desktop will display a prompt Backup has been restored successfully, restart the Webgility application and the backup is restored.