This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Connect Client VPN users do not have access to SQL database

I got an user using a computer not joined to the domain.

She connects to our LAN through the Connect Client VPN. She can access to all the resources in our servers except for a software that connect to a SQL database.

She can ping the server where the SQL database is hosted, as well as the server where the software runs.

This is my firewall rule:

and the setting for the VPN users:

This thread was automatically locked due to age.

Top Replies

Nafets over 3 years ago +1

Have you checked the local firewall of the server the sql database is hosted? Maybe you have to add the Sophos ConnectClient network as remote network in the applicable firewall rule.

0 Nafets over 3 years ago

Have you checked the local firewall of the server the sql database is hosted? Maybe you have to add the Sophos ConnectClient network as remote network in the applicable firewall rule.
Cancel
Vote Up +1 Vote Down

Cancel
0 FormerMember over 3 years ago
Hi Johana, Thanks for reaching out to Sophos Community.

Rules seem proper. As Nafets mentioned, Check once with the Firewall on server as well.

If everything seems proper, Then try by taking a tcpdump

Take SSH access, go to option 5 > option 3 Advanced shell.

Run the command --> tcpdump host x.x.x.x (x.x.x.x is IP that is leased by the Firewall to VPN connected machine)

Run the command and then try to access the SQL server/application and share the results.
Cancel
Vote Up 0 Vote Down

Cancel
0 Johana Romero Melo over 3 years ago in reply to Nafets

HI Nafets,

When you say local firewall of the server, Do you mean the WIndows Defender firewall?

The XG125 is the firewall for all ours servers, and it is the same that provide the Connect Client VPN.

Thank you.

Johana
Cancel
Vote Up +1 Vote Down

Cancel
0 Nafets over 3 years ago in reply to Johana Romero Melo

Yes i meant Windows Defender firewall. Have you checked that?
Cancel
Vote Up 0 Vote Down

Cancel