How To Configure Windows Firewall For TCP Ports

Article ID: ias-6221
Article Name: How To Configure Windows Firewall For TCP Ports
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