I am using UPS Worldship which connects to my database via an OBDC connection. This uses TCP and a port number. At the moment, I have a custom packet rule set up on our SQL Server to block any access from the internet. However, when I try to connect to the database from Worldship, the firewall blocks it. I checked the firewall log and it only shows two colons in the address part. How can I allow a connection to the software when its local?
Set firewall to private and reboot
Is your firewall network profile in private or puplic mode?
Setting up Firewall Application Rules in Avast Antivirus
https://support.avast.com/en-eu/article/Antivirus-Firewall-Application-Rules
=================================================================
NOTE:The Network profiles control the settings which determine how strictly Firewall protects your PC.
Private: a lower level of security suitable for when your PC is connected to a trusted network such as your home or work network.
This profile enables better connectivity, and permits all communication within the network.
Public: a higher level of security suitable for when your PC is connected to a public network such as in a cafe or airport.
Because public networks present greater security risks, no incoming communication is permitted when this profile is set.
=================================================================
The firewall is currently set on Private network. I have a custom packet rule set up for my SQL Server application to block anything inbound from the internet. However connecting to the database via ODBC, it blocks it even when its on the same computer
Try the Geek Area settings, mentioned here: https://forum.avast.com/index.php?msg=1505540
Hi. Thank you, I have tried the settings in the Geek Area but to no avail. I dont know if this helps. In the firewall log, it comes up with the following when its blocked access to my SQL
Remote Address: Blank, Remote Port: 0. Local Address: ::, Local port: 1434, Protocol: TCP
I have tried to create an allow rule in Packet Rules for address “::” but no luck
Hi, probably best to contact support: https://support.avast.com/contact