1 article Firewall

Microsoft SQL Server Firewall Configuration Script

Once you have you Microsoft SQL Server installed, you will need to open some port in the firewall if you intend to access it from another server/computer.  Copy and paste the following commands to open all common ports used by SQL Server:

Here are the configs for miscellaneous applications: