Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    How to port forward mssql in pfsense

    NAT
    4
    4
    2.6k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • V
      vijayl90
      last edited by

      Hi All,

      I have created NAT Policy to allow MSSQL on LAN in pfsense. To allow from public ip, but not able to connect from public ip. I have allowed other ports on LAN, I am able to access them. But Not able to access MSSQL from public IP.

      please help me.

      Thanks

      1 Reply Last reply Reply Quote 0
      • M
        muswellhillbilly
        last edited by

        Short answer: Don't make SQL available from your public IP. It's a quick route to having your database hacked.

        Longer answer: You haven't posted your rules so nobody could comment anyway. But regardless of all that, I still don't suggest you put your SQL server on a public IP unless you have a sincere desire to become a hacking victim.

        1 Reply Last reply Reply Quote 0
        • johnpozJ
          johnpoz LAYER 8 Global Moderator
          last edited by

          Is there a firewall on this mssql server?  Did you even enable tcp/ip for mssql?  What version of mssql are you running?

          I am with muswellhillbilly here - allowing public internet to access your sql not a normally a very good idea.

          An intelligent man is sometimes forced to be drunk to spend time with his fools
          If you get confused: Listen to the Music Play
          Please don't Chat/PM me for help, unless mod related
          SG-4860 24.11 | Lab VMs 2.7.2, 24.11

          1 Reply Last reply Reply Quote 0
          • jimpJ
            jimp Rebel Alliance Developer Netgate
            last edited by

            If someone remote must access the SQL server, make them use a VPN to do it.

            Never expose any database directly to the world.

            Remember: Upvote with the 👍 button for any user/post you find to be helpful, informative, or deserving of recognition!

            Need help fast? Netgate Global Support!

            Do not Chat/PM for help!

            1 Reply Last reply Reply Quote 0
            • First post
              Last post
            Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.