Problem
Port 1433 is closed on the SQL server.
Solution
Inbound traffic on TCP Port 1433 needs to be allowed on the SQL server.
Connect to your SQL server.
Open the Windows firewall.
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 case, 1433 stands for the SQL server, and 1434 for the SQL server browser.
In this step, leave the default selection: Allow the connection.
Select the profiles for which this rule applies.
Note: If the SQL server is in the same domain with other servers and you wish to open this port only for the domain traffic, it is enough to select Domain. For other scenarios use the Private or Public profile option
Specify the name and the description of this rule.
Inbound traffic on the SQL server is now allowed and SQL connection should be available!
FAQs
Enable TCP/IP in the SQL Server
Expand the Configuration Tools subfolder and right-click on SQL Server Configuration Manager. Click on Run as Administrator. Select SQL Server Network Configuration and click Protocols for SMTKINGDOM. In the right pane, right-click TCP/IP and click Enable.
Is 1433 port secure for SQL? ›
Microsoft SQL Server uses the default port 1433 for all database connections. It is a common security risk in many database environments because database professionals typically do not change the default port. It is a well-known port, and intruders can utilize this opportunity to access SQL Server.
How to check if port 1433 is working for SQL Server or not? ›
Click the Start button on the local machine and type “CMD” into the search programs and files field. Enter “Telnet IP-address 1433” in the Command Prompt. If port 1433 is not open, it will immediately return an error. We will be able to connect to the MS-SQL server if port 1433 is open.
Why is port 1433 blocked? ›
By default, Microsoft Windows enables the Windows Firewall, which closes port 1433 to prevent Internet computers from connecting to a default instance of SQL Server on your computer. Connections to the default instance using TCP/IP aren't possible unless you open port 1433.
How to check if SQL Server is accepting TCP/IP connections? ›
You can check TCP/IP connectivity to SQL Server by using telnet. For example, at the command prompt, type telnet 192.168. 0.0 1433 where 192.168. 0.0 is the address of the computer that is running SQL Server and 1433 is the port it is listening on.
How do I allow TCP connection on a port? ›
In the navigation tree, select Inbound Rule, and then in the Actions pane, click New Rule. On the Rule type panel, select Port and then click Next. On the Protocol and Ports panel, select TCP, enter the TCP/IP port numbers that you set in steps 3 and 4 in Specific local ports, and then click Next.
How to open TCP port for SQL Server? ›
In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration, select Protocols for <instance name>, and then in the right pane double-click TCP/IP. If you have trouble opening SQL Server Configuration Manager, see SQL Server Configuration Manager.
Can I change SQL port from 1433? ›
Yes, it's available, but it's not recommended if you only have one SQL Server instance on the Server. We can use SQL Server Configuration Manager to configure the custom TCP port, remember to leave the TCP Dynamic Ports null.
What is the alternative port for 1433? ›
The alternative port is 14330. If you find that your ISP or firewall is blocking the standard SQL port (1433), you can configure your SQL client to connect via the alternative port.
What is the vulnerability of port 1433? ›
Several vulnerabilities come with using port 1433. These include injection attacks, which can lead to data breaches if not adequately mitigated. Like other database ports, including 1434 and 3306, these are frequently targeted by attackers for the distribution of malware, or as direct targets in DDoS attacks.
In the SQL Server Network Configuration menu, select Protocols for MSSSLSERVER. Right-click TCP/IP and select Properties. In the window that opens, click the IP Addresses tab. Check what port the SQL Server is currently running on.
What is port 1433 used for? ›
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.
