How do I allow SQL Server ports in Windows Firewall?

Question

Solution Connect to your SQL server. Open the Windows firewall. Click on Inbound Rules. Select New Rule. Select the Port type of the rule. Specify the ports 1433 and 1434 to which this rule applies inside the Specific local ports area. . In this step, leave the default selection: Allow the connection.

How enable SQL Server port in Windows Firewall?

Open Windows Control Panel and select System and Security. From the System and Security window, click Windows Defender Firewall. From the Windows Defender Firewall window, click Advanced Settings. Add the port SQL uses for TCP.

What firewall ports need to be open for SQL Server?

Port 1433 for TCP is needed to connect to the SQL database instance. By default, SQL will attempt to use 1433. If that port is unavailable, it will automatically choose another port. If this is the case, that port will need to be opened through the firewall instead.

How do I open port 1433 on Windows Firewall?

Following the steps below will enable port 1433 in your windows firewall.1Click Start.2Click Run.3Type Firewall.cpl and then Click OK.4Click the Exceptions Tab.5Click Add Port.6In the Port Number, type 1433.7Click the TCP button.8Type a name in the name box and then Click OK.

How do I allow SQL Server remote connections to firewall?

Configure SQL Server machine1Windows Firewall ->Advanced Settings->Inbound Rules. ... 2Run SSMS (SQL Server Management Studio) on SQL Server machine. ... 3Server Properties - > Connections -> Allow Remote Connections ..” ... 4Add a SQL login (if not already there)5Enable SQL Service to listen on TCP/IP. ... 6Restart SQL Server Service.

Expert · Answer