Many of the programs made by dESCO require Winsock TCP/IP connectivity between the computers in your office. Firewalls exist to stop that from happening. This article shows you what programs and ports you need to allow through your Windows Firewall to allow ESC and SQL to communicate. While these instructions do not apply to third-party firewalls, the directories and program files remain the same. Consult your IT company or malware provider's support for assistance with any third-party firewalls.
Firewall Configuration for Microsoft SQL Server
- Click Start → Settings → Control Panel. If you are using Windows 8 or 10, right-click on your Start icon and select Control Panel.
- Open Windows Firewall. This option may or may not be listed under System and Security.
- Click the Allow a program or feature through Windows Firewall button.
- Click the Change settings button and agree with any security prompts that appear.
- Click the Allow another program... button.
- Click the Browse button and select sqlbrowser.exe. This is typically found in C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe or C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe on 64-bit operating systems. Once you have the file selected, click Open.
- Click Add to submit the exception.
- Find the new exception in the list and check all three boxes (Domain, Home/Work and Public).
- Repeat steps 5 - 8, this time selecting sqlservr.exe. This is typically found in C:\Program Files\Microsoft SQL Server\MSSQL10_50.ESC\MSSQL\Binn\sqlservr.exe. This is true even if you are running a 64-bit operating system.
Firewall Configuration for ESC
Allow the following programs or ports through the firewall on your ESC Server computer. Follow the instructions above for creating exceptions in your Firewall and search for the directories below.
Note: On the workstation computers, you only need to add an exception for port 443 so that they can communicate with our licensing servers.
|Accounting Server||C:\Program Files\dESCO\ESC Accounting Server\ESC Accounting Server.exe||6050|
|On a 64-bit machine: C:\Program Files (x86)\dESCO\ESC Accounting Server\ESC Accounting Server.exe|
|Connections Server||C:\Program Files\dESCO\ESC Connections Server\ESC Connections Server.exe||6090|
|On a 64-bit machine: C:\Program Files (x86)\dESCO\ESC Connections Server\ESC Connections Server.exe|
|SQL Server||C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe||1433 or 1434|
|OR C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe|
|SQL Browser||C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe||1433 or 1434|
|OR C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe|
* Access to ESC Licensing is necessary any time ESC is upgraded.
If more than one instance of SQL Server is installed on the computer it may be necessary to search for all instances of sqlbrowser.exe and sqlservr.exe and add them to the Exceptions list.
These programs can also be excluded from other firewalls to allow ESC clients to connect.