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

Installing SQL Server 2022 and Restoring a Webgility Desktop Database Backup

This article helps Webgility Desktop user by providing step-by-step instructions for restoring a Webgility Desktop database from backup and manually installing SQL Server 2022. These procedures are essential for system migration, recovery after failures, and troubleshooting database-related issues.

This article covers two important processes for maintaining Webgility Desktop:

  • Restoring a database from backup

  • Manually installing SQL Server 2022 for Webgility Desktop

Use these guides when migrating systems, recovering from failures, or troubleshooting database issues.

 Part 1: How to Restore a Webgility Database Backup

 When Should You Restore?

  • Moving to a new machine

  • Recovering from system failure

  • Reverting to a previous configuration

Note: You must install Webgility Desktop and SQL Server before restoring the backup.

 Steps to Restore the Database:

  1. Launch Webgility Desktop

  2. Navigate to: System > Database > Restore
    (Image placeholder)

  3. A warning popup will appear:

    • Click Yes to proceed—this will overwrite existing data

  4. Browse to locate your .bak file (e.g., UnifyDB.bak)

  5. Select the file and click Open

  6. Wait for the success message, then close Webgility

  7. Relaunch the application to see your restored data

 Identify the Workstation with SQL Server

The .bak file is created on the machine where the SQL database is hosted.

To identify the SQL host:

  1. Go to: C:\Webgility\UnifyEnterprise\XML

  2. Open the apiconfig file using Notepad

  3. Look for the value next to Instance Name — this is your SQL host machine

 Using RightNetworks (Now RightWorks)?

If you're hosted by RightNetworks, contact them to request a backup or perform a DB upgrade:

  • Backup Request:
     support2@rightnetworks.com
    t2vendor@rightnetworks.com

  • DB Upgrade:
     support2@rightnetworks.com
    provisioning@rightnetworks.com

 Part 2: How to Manually Install SQL Server 2022 for Webgility Desktop

Why Install SQL Manually?

Automatic SQL installation may fail due to:

  • System permission restrictions

  • Firewall or antivirus blocking

  • Pre-existing SQL conflicts

This guide walks you through a manual SQL Server 2022 Express Edition installation for Webgility Desktop.

 Prerequisites:

Step-by-Step Installation:

  1. Download SQL Server 2022 Express
     Get it directly from Microsoft:
    Download SQL Server Express

  2. Run the Installer
    • Choose Custom installation

    • Click Install

  3. SQL Server Installation Center Launches
    • Select: New SQL Server stand-alone installation

    • Accept license terms, then click Next

    • Skip Microsoft Updates, then proceed

  4. Handle Firewall Warning (if shown)
    • Open Control Panel > System and Security > Windows Defender Firewall

    • Temporarily disable it under Private and Public settings

  5. Feature Selection
    • Select only:

      • Database Engine Services

      • SQL Server Replication

      • Local DB

    • Click Next

  6. Instance Configuration
    • Change Named Instance to: UNIFY
      (Use UNIFYNEW if upgrading an existing install)

    • Click Next

  7. Server Configuration
    • Set Startup Type to Automatic for:

      • SQL Server Database Engine

      • SQL Server Browser

  8. Authentication Mode
    • Choose: Mixed Mode

    • Enter:

      • Username: sa

      • Password: Webgility2011 (W must be capitalized)

    • Click Next

  9. Finish Installation
    • Once the process completes, click OK on the success prompt

    • Close the setup wizard

 Final Steps:

  • Open Webgility Desktop and proceed with setup

  • If restoring a backup, follow the steps from Part 1