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

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

  1. Make sure you setup both inbound and outbound rules. Also, at least on 2008 R2, you need to setup inbound and outbound exceptions for sqlserver.exe and sqlbrowser.exe

Leave a Reply

Your email address will not be published. Required fields are marked *