Menu

Join the Conversation

To sign in, use your existing MySonicWall account. To create a free MySonicWall account click "Register".

Sign In Register

SQL Servers using Dynamic TCP Ports

semi_demi_godsemi_demi_god Newbie ✭
in VPN Client

We have various types of SQL databases, (DB2, Microsoft, MySQL). All the database servers use Dynamic Ports for SQL Connections. SQL clients connect to the SQL database with no issue when the clients are within the firewall; However, when the users try to connect to the SQL databases over the VPN the users cannot connect to the SQL severs.

The users are using Global VPN Client 4.10.8

The firewall is a NSa4700 running 7.1.1-7051

It appears that the Firewall is blocking or dropping the SQL traffic if the SQL server is using Dynamic Ports. So,, without setting up fixed ports on the SQL server. How do you configure the firewall to allow connections to SQL server if they are using Dynamic Ports.

Just to be clear, I am not trying to make the SQL servers public. I am trying to connect to SQL servers across the VPN using the Global VPN Client.

Thank you

Category: VPN Client
Reply

Answers

  • MarkDMarkD Cybersecurity Overlord ✭✭✭

    Maybe changing the SQL dynamic port range to a static port?

    TCP Dynamic Port. Note the port number

    IPALL.png

    However unless you have set VPN-LAN rules set - there are none by default setting up a VPN implies trust

Sign In or Register to comment.