How to Add Ports in the Firewall for Webgility

This article provides instructions to Webgility Desktop users for configuring Windows Firewall to ensure Webgility Desktop can connect properly, especially when add-on users face errors while connecting to the SQL database. It explains how to create inbound and outbound rules for required TCP and UDP ports (1433 and 1434) and how to add the Webgility Desktop application (Unify.exe) to firewall exceptions. Proper firewall configuration helps maintain smooth communication between Webgility Desktop and the SQL database.

Overview:

To allow Webgility Desktop to connect properly, you may need to add inbound and outbound rules in your Windows Firewall. Follow these steps if an add-on user is encountering errors when connecting to the SQL database.

Step 1: Add Inbound Rules

Adding a TCP Port (1433)

1). Open Firewall Advanced Settings by navigating to Control Panel > System and Security > Windows Defender Firewall > Advance Settings.

2). In the top left corner, click on Inbound Rules, then select New Rule.

3). Choose Port and click Next.

4). Select TCP and enter 1433 in the Specific Local Ports field, then click Next.

5). Choose Allow the connection, then click Next.

6). Select all three profiles: Domain, Private, and Public, then click Next.

7). Name the rule TCP PORT, then click Finish.

Adding a UDP Port (1434)

In Inbound Rules, select New Rule.

Choose Port and click Next.

Select UDP and enter 1434 in the Specific Local Ports field, then click Next.

Choose Allow the connection, then click Next.

Select all three profiles: Domain, Private, and Public, then click Next.

Name the rule UDP PORT, then click Finish. In Inbound Rules, select New Rule.

Step 2: Add Outbound Rules

Open Windows Defender Firewall with Advanced Security.
Click on Outbound Rules in the top left corner.
Follow the same steps to add TCP Port (1433) and UDP Port (1434), as you did for Inbound Rules.

Step 3: Add the Webgility Desktop Application to Exceptions (both Inbound and Outbound)

Adding Unify.exe to Inbound Rules

1). In Inbound Rules, click on New Rule.

2). Select Program and click Next.

3). Select Program Path, browse to the Webgility Desktop application (Unify.exe), and click Open.

4). Choose Allow the connection and click Next.

5). Select all three profiles: Domain, Private, and Public, then click Next.

6). Name the rule Unify.exe, then click Finish.

Adding Unify.exe to Outbound Rules

Repeat the same steps under Outbound Rules to add Unify.exe to the Outbound Rules list.

By following these steps, Webgility Desktop will be able to connect through your firewall without issues.