How to open up the Windows firewall for SQL Server 2008 on Windows Server 2008 R2

After you have installed SQL Server, you might have noticed that the firewall will block access to it.

In order to remedy this, you will have to open 2 ports in the firewall.

TCP port 1433 for the actual SQL Server engine, and UDP port 1434 for the SQL Server Browser.

This could be done from the GUI, but I have found that it’s more convenient to do it from an elevated command prompt.

Or follow the manual GUI steps in this MSDN article:

How to: Configure a Windows Firewall for Database Engine Access