How To Configure Windows Firewall For TCP Ports

Article ID

ias-6221

Article Name

Created Date

30th April 2008

Product

Problem

By Default SQL Server uses TCP Ports for communication with applications. If you are running an application that requires connectivity with the SQL Server, you must first establish which port SQL Server is listening on then enable this port in your windows firewall

Resolution

Following the steps below will enable a static port for SQL Server in your windows firewall. To establish if a Dynamic or Static TCPIP Port is being used by the SQL Server please refer to KB IAS-6218

Click Start and then Click Run

Type Firewall.cpl and then Click OK

In the top left Click Advanced Settings

In Advanced Settings create new Inbound and Outbound Rules.

You will need to select Port | TCP |

In the Specific Local Ports, type the port number established above and then Allow the connection on the next screen. Apply to Domain ,Private, and Public

Type a name in the name box and then Click OK NOTE: IRIS are unable to provide any additional information regarding your firewall product. Should further assistance be required it is advised that you contact your own IT Support Provider or the 3rd Party firewall provider. Related Articles KB IAS-6183 : How Do I Create An Exception for SQL Server 2008 in Windows Firewall? KB IAS-6184 : How Do I Create An Exception for SQL Server Browser in Windows Firewall? KB IAS-6219 : How To Configure Windows Firewall For UDP Port 1434 KB IAS-6220 : How To Configure Windows Firewall For TCP Port 1433

Share This Page