How do I enable Port 1433 on my firewall?

Question

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

How do I check if a port 1433 is open?

On the local machine, click the Start button and enter “CMD” in the search programs and files field. If the port 1433 is closed, an error will be returned immediately. If the port 1433 is open, you will be able to connect to the MS-SQL server.

Why is port 1433 blocked?

Cause. The SQL Server instance is possibly running on a non-default port (1433 is the default port) or a firewall such as the Microsoft Windows Firewall preventing access to the port used in the JDBC connection.

How do I open port 1433 on my router?

#3 – Configure SQL Server Configuration Manager1Launch the SQL Server Configuration Manager.2Expand SQL Server Network Configuration.3Select Protocols.4Right click on the option “TCP/IP” and select “Properties“5Click on the IP addresses tab.6Scroll down to “IPAll“7For TCP Port, put in 1433.Configure Port Forwarding for Remote Workers (SQL) - CurrentWare

How do I allow SQL Server in firewall settings?

Allow the SQL Server applications in the Firewall1Open Windows Control Panel and select System and Security.2From the System and Security window, click the link to Allow an app through Windows Firewall.3Allow the SQL Server Browser: ... 4Click the Browse button. ... 5Allow the SQL Server Application: ... 6Click the Browse button.How To: Configure Windows Firewall for SQL Server (KB13103002 ...

Expert · Answer