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
We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.