Thank you for your feedback.

Was this useful?

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

  • Thank you for your feedback.

    Was this useful?