Skip to content

Instantly share code, notes, and snippets.

@bradbrowne

bradbrowne/add-mssql-server-port-1433-to-macos-firewall.md

Created June 29, 2022 07:38
Show Gist options
  • Save bradbrowne/68950d628702fd355569614058a67844 to your computer and use it in GitHub Desktop.
Save bradbrowne/68950d628702fd355569614058a67844 to your computer and use it in GitHub Desktop.
Download ZIP
Add Microsoft SQL Server port 1433 to macOS Firewall rules
Raw
add-mssql-server-port-1433-to-macos-firewall.md

Open the /etc/pf.conf file in your favourite text editor in the Terminal:

sudo vim /etc/pf.conf

Add the following to the bottom of the /etc/pf.conf file:

pass in proto tcp from any to any port 1433

Flush and restart the service with the updated contents:

sudo pfctl -f /etc/pf.conf

This should result in the following output:

pfctl: Use of -f option, could result in flushing of rules
present in the main ruleset added by the system at startup.
See /etc/pf.conf for further details.

No ALTQ support in kernel
ALTQ related functions disabled
@tedonmain
Copy link

thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment