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

Webgility Desktop Database Login Failure and Optimization Utility Guide

This article helps Webgility Desktop users troubleshoot login failures in Webgility Desktop caused by the error message “Database already exists.” It explains that this issue typically arises from database access problems due to connectivity failures or interrupted upgrades and provides steps to resolve it.

Step-by-Step Resolution


 1. Restart SQL Services

  1. Open Windows Services:
  • Press Windows + R, type services.msc, and press Enter

  • Locate SQL Server (UNIFY) or your custom SQL instance

  • Right-click and select Restart

  • Also restart the SQL Server Browser service

 2. Reconnect Through Webgility

  1. Launch Webgility Desktop
     Open the Webgility application after restarting services.
  2. Connect to Existing SQL Server
  • Select "Connect to an existing SQL Server"

  • From the list, choose the correct instance (ComputerName\UNIFY or ComputerName\WEBGILITY)

  1. Use SQL Server Authentication
  • Username: sa

  • Password: Webgility2011 (case-sensitive)

  • Click Connect

 If the SQL Server is on a different machine, click Browse More and wait for available instances to load.

 Run Webgility Database Optimization Tools

 3. Run UnifyDBUtility (Database Optimization Tool)

This tool optimizes performance and shrinks the database.

Steps:

  1. Close Webgility & Scheduler on all machines
    (Use Task Manager to end any active processes)

  2. On the primary machine, navigate to:
    C:\Webgility\UnifyEnterprise

  3. Locate and run UnifyDBUtility.exe

  4. Follow prompts to:

    • Confirm all Webgility apps are closed

    • Perform a backup before optimization

    • Allow the process to complete uninterrupted

  5. After success message, close the tool and relaunch Webgility

 4. Run UnifyDBUpgrade (Reindex & Repair Utility)

Use this tool to reindex the database or when Webgility requests a DB upgrade.

Steps:

  1. Close Webgility & Scheduler on all machines

  2. On the database host machine, go to:
    C:\Webgility\UnifyEnterprise

  3. Run UnifyDBUpgrade.exe

  4. Wait for the success message, then log back into Webgility

 Conclusion

By restarting SQL services and running Webgility's built-in utilities (DBUtility and DBUpgrade), users can resolve login and database errors efficiently. These tools help ensure stable connectivity and improved application performance.