MSSQL app and port unblock problem?

[Rob Morin 0]

Hey all.

Been pulling my hair out of my head on this, what I think should be easy to do.

I have an MSSQL server running on the local lan  that workstations connect to.

I created a policy here for the 2 executables that are needed for the workstation app to work.

You can see above what i entered for the rules.(forget about the RDP thing)

I then moved the 2 rules to the top of the rule list.

Now when I go onto to the server/computer in question where MSSQL runs, and check the agent/client it shows the rules are there.

 

Now when I run the app on the workstation and view the live traffic on the server/computer that hosts MSSQL server i get the below.

 

And when I try to use the unblock feature i get the below..

So what gives, what am i doing wrong??

 

Any help Appricated.

Thanks and have a great day!

Rob..

[Marcos 5,189]

I'd recommend that you:
1, Enable advanced logging under Help and support -> Technical support
2, Reproduce the issue
3, Stop logging
4, Collect logs with ESET Log Collector.
5, Upload the generated archive here and also open a support ticket with your local ESET distributor.

[Rob Morin 0]

Thanks for the prompt reply, here is the archive....

Have a great day!

 

ees_logs.zip

[Marcos 5,189]

You have several options:

1, Unblock the desired communication / create the appropriate rule via the firewall troubleshooting wizard

2, Switch to interactive or learning mode for a while until the appropriate rule is created

3, Manually create a permissive rule for C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe and the local UDP port 1434.

[Rob Morin 0]

Hey Marcos, I am not an Eset Guru, but with your suggestions I did the following to resolve my issue:

 

Switched to interactive mode, ran the app on a remote workstation and observed the incoming connections.

The end result was the below settings to make this app work:

 

On the Client side I needed to allow port UDP & TCP port 1434, 1433

 

On the Server side I needed to allow the following:

c:\program files (x86)\microsoft sqls erver\90\shared\sqlbrowser.exe

Port 1434(UDP & TCP) and Port 5075

 

c:\program files\microsoft sql server\mssq11.clinicmaster\mssql\binn\sqlservr.exe
 Port 1434(UDP & TCP)

 

The one port I did not think of was the below

Port 137 for file access to the shared db file on the server

 

You can mark this as SOLVED

 

Have a great day!