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

Troubleshooting SQL Installation Failures for Webgility Desktop

This article helps Webgility Desktop users resolve SQL Server installation failures related to Webgility Desktop. It provides step-by-step instructions for installing SQL Server on a new machine or recovering from a failed or incomplete installation.

Prerequisites

Before beginning, ensure the following:

  • You have local administrator rights on the machine.

  • All Windows Updates have been installed.

  • The machine has sufficient disk space for the SQL Server installation.

  • Required dependencies like .NET Framework and Visual C++ Redistributables are installed.

Step 1: Review Installation Error Logs

  1. If a previous SQL installation failed, review the SQL Setup Bootstrap logs:

    pgsql
    CopyEdit
    C:\Program Files\Microsoft SQL Server\<version>\Setup Bootstrap\Log\

  2. Open the most recent folder and look for:

    • Summary.txt

    • Detail.txt

  3. Identify any error messages or codes that indicate the root cause, such as:

    • Missing prerequisites

    • Permissions issues

    • Incomplete setup

Step 2: Remove Previous or Failed Installations

  1. Go to Control Panel > Programs and Features.

  2. Uninstall any partially installed SQL Server components.

  3. Restart the computer before proceeding with a fresh installation.

Step 3: Confirm System Requirements

Verify the following:

  • You are logged in with a Windows admin account.

  • All .NET Framework versions required by SQL are installed.

  • Any required Visual C++ Redistributables are present.

  • Your antivirus/firewall is temporarily disabled (if permitted), as these can interfere with installation.

Step 4: Reinstall SQL Server

  1. Right-click the SQL Server setup file and choose Run as administrator.

  2. Follow the installation prompts carefully.

  3. Avoid selecting the PolyBase feature unless required, as it can cause large dump log files.

  4. Monitor for any errors during installation and document them if they occur.

Step 5: Verify SQL Installation

  1. After installation, confirm that the SQL Server services are running.

  2. Optionally, launch SQL Server Management Studio (SSMS) to verify connectivity to the new instance.

Step 6: Restore the Webgility Database (if needed)

If you're reinstalling SQL due to a migration or recovery:

  1. Place the .bak file (e.g., UnifyDB.bak) into:

    makefile
    CopyEdit
    C:\Webgility

  2. Launch Webgility Desktop and navigate to:
    System > Database > Restore

  3. Select the backup file and follow the prompts.

  4. Restart Webgility Desktop after the restore is complete.

Final Notes

  • Once the database is restored, verify that sales channel settings, company mappings, and transactions are accessible.

  • Always recommend maintaining regular backups to avoid future data loss.

  • Test basic functions in Webgility Desktop to ensure SQL is functioning correctly.