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

How to port forward mssql in pfsense

Scheduled Pinned Locked Moved NAT
4 Posts 4 Posters 2.7k Views
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 Oct 10, 2016, 2:34 PM

    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 Oct 11, 2016, 1:10 PM

      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
      • J
        johnpoz LAYER 8 Global Moderator
        last edited by Oct 11, 2016, 1:27 PM

        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.8, 24.11

        1 Reply Last reply Reply Quote 0
        • J
          jimp Rebel Alliance Developer Netgate
          last edited by Oct 11, 2016, 3:27 PM

          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
          4 out of 4
          • First post
            4/4
            Last post
          Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.
            This community forum collects and processes your personal information.
            consent.not_received