SQLserver2012 TCP/IP 1433 port Problem solving method

After many MSSQL installations are complete, calling 1433 (the default port) is a failure, and the workaround is described in detail here.

First, we need to open the Telnet service on the computer to locate the problem. Use Telnet under cmd, if the quote command does not exist The description is not turned on. The opening method is as follows:

Control Panel--"Click to open or close Windows Features", will pop up the Windows Features dialog box, we found in the "Telnet Server" and "Telne client" two, then the previous tick to open the corresponding service, tick, remember to click on the bottom of the confirmation save OH Such as:

B. Type the following command in CMD

telnet localhost 1433

If a connection failure occurs, there is a problem with the configuration, proceed to the next step

Third, configure TCP/IP 1433 port

1. Open the SQL Server Configuration Manager tool, and close the corresponding instance service in the services

2. In SQL Server Network configuration, locate the TCP/IP config and open the dual machine, as

(Note: Ip1-ip6 All to enable, then set the dynamic port all to 1433 in the Ipall)

3. Then start the previously closed instance.

Iv. verify the Telnet,ok again to indicate that the 1433 port setting is successful