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

How to Troubleshoot Webgility Desktop Add-On Computer Connection Issue

Overview:

This guide explains how to troubleshoot connection issues between the Webgility Desktop application installed on an add-on computer and the database located on the master (server) computer.

Key Concept:

The database is installed only on the master (server) computer, and all add-on computers must connect to the same Local Area Network (LAN) to access the database.

Steps to Troubleshoot:

Step 1: Verify Network Connection

Ensure the add-on computer is on the same LAN as the server.

01. Open Command Prompt on the add-on computer by typing cmd in the search bar.

 

02. Type ipconfig and press Enter to get the IP address of the add-on computer.

 

03. On the server computer, open Command Prompt and type ping [IP address] (replace [IP address] with the one from the add-on computer, e.g., ping 192.168.0.30).

 

04. If the computers are on the same network, the Lost percentage should be zero.

Step 2: Activate SQL Protocols

01. On the server computer, go to C:\Windows\SysWOW64, type sql in the search bar, and open SQLServerManager.

 

02. In the left-hand menu, expand SQL Server Network Configuration.

03. Under the appropriate protocols (e.g., Protocols for WEBGILITY or Protocols for UNIFY), right-click on Shared Memory, Named Pipes, and TCP/IP and enable them.

Step 3: Configure Windows Firewall Rules

If the Windows Firewall is enabled, follow this article to automatically add the required ports and permissions for Webgility.

Step 4: Restart SQL Services

Important: Ensure the SQL Server Browser is running in Network Mode. If it is running as a local service, follow the instructions to move it to Network Mode, then restart the service.

Step 5: Configure the Add-On Computer

  • Open the Webgility application on the add-on computer and log in. The Database Configuration Form will open.

  • Select Connect Webgility database to an existing SQL Server.

  • Click the dropdown under Locate SQL Server, then select Browse For More.

  • Choose the correct instance, which will be a combination of the server’s name and the database name (e.g., SERVERNAME/DATABASENAME).

  • Select SQL Server Authentication and enter:

    • Username: sa

    • Password: Webgility2011

  • Click Connect.

The add-on computer should now connect to the database on the server.

Additional Steps:

If the above steps don’t work, try restarting the server and manually adding the necessary ports.

Still, facing the issue?