Adding SQL Server to Windows Firewall Exception

SQL Server requires 2 main ports to function:

TCP – 1433        SQL Transactions

UDP – 1434       SQL Browser Service

If the customer has Windows Firewall enabled these must be allowed through the Windows Firewall where the SQL Server resides.

Create an incoming rule for TCP – Control Panel à Windows Firewall à Advanced Setting

Right click Inbound Rules à New Rule…

Choose Rule Type Port

Select TCP and enter port number 1433

Allow the connection

Choose Domain and Private in the Profile screen

Give the rule a name such as SQL TCP à Finish

Create an incoming rule for UDP – Control Panel à Windows Firewall à Advanced Setting

Right click Inbound Rules à New Rule…

Choose Rule Type Port

Select UDP and enter port number 1434

Allow the connection

Choose Domain and Private in the Profile screen

Give the rule a name such as SQL UDP à Finish

Once the rules are created SQL Servers default configuration of using random / dynamic ports must be disabled.

Go to SQL Server Configuration Manager à SQL Server Network Configuration à Protocols for InstanceName

Right click TCP/IP à Properties à IP Addresses

Scroll to the bottom of the window until you come to IPAll

Set TCP Dynamic Ports to be blank (nothing in the field)

Set TCP Port to 1433

Restart the SQL Server Service for the instance that has been configured if safe to do so.