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

How to Resolve SQL connection, Update Webgility Desktop, and Manage Sales Channels

This article guides Webgility Desktop users through three key maintenance tasks: resolving SQL connection disconnect errors, manually updating the application, and removing inactive or unused sales channels. Each section includes step-by-step instructions to help maintain optimal performance and stability.

 

 Overview

This article walks you through three important maintenance tasks in Webgility Desktop:

  1. Fixing SQL Connection Disconnected errors

  2. Manually updating Webgility Desktop

  3. Removing inactive or unused sales channels

Each section provides step-by-step guidance to help keep your Webgility application running smoothly.

 Part 1: Resolving SQL Connection Disconnected Issues

Why This Happens:

The “SQL Connection Disconnected” error may appear due to:

  • SQL Server service being stopped

  • Network interruptions

  • Maintenance tasks like indexing or backups

 Steps to Resolve:

1. Open Windows Services:

  • Click Start > Type Services > Press Enter

2. Restart SQL Services:

  • Locate: SQL Server (UNIFY) or your instance name

  • Right-click > Select Restart

  • Also, restart: SQL Server Browser

3. Reopen Webgility Desktop:

  • Open Webgility after services are restarted

4. Connect to SQL Server:

  • Click: Connect to an existing SQL Server

  • Under Locate SQL Server, select:
    YourComputerName\UNIFY or YourComputerName\WEBGILITY

5. Use SQL Authentication:

  • Choose: Use SQL Server Authentication

  • Username: sa

  • Password: Webgility2011 (W is capitalized)

  • Click Connect

 If SQL Server is on another machine:
Use Browse more to load remote SQL instances.

 Part 2: How to Update Webgility Desktop

Webgility regularly provides updates that enhance functionality, resolve bugs, and ensure compatibility.

 Steps to Update:

  1. Login to Webgility Desktop

  2. Go to Help > Terms and Privacy to view your current version

  3. Click Help > Check for Updates

In the Update Window:

  • Review available version

  • Ensure "Take database backup before update" is checked

  • Choose a save location when prompted

  • Let the installer complete the update

  • Webgility will reopen and upgrade the database

To confirm:

  • Go back to Help > Terms and Privacy

  • Check that the new version is listed

Webgility is now updated successfully.

 Part 3: How to Remove an Inactive Sales Channel

If you have sales channels that are no longer active, it’s best to remove them for clarity and improved performance.

 Steps to Delete a Sales Channel:

  1. Open Webgility Desktop

  2. Navigate to Connections > Sales Channels

  3. Under the list of connected channels:

    • Identify the inactive one

    • Click the Trash/Delete icon next to it

  4. Confirm the deletion when prompted

 This helps reduce sync issues and speeds up processing.