Resolution is not enabled in Windows Server 2008 when you install SQL Server R2 1433 port

Source: Internet
Author: User

SQL Server typically has a default port of 1433, but sometimes encounters an issue where port 1433 cannot be connected, and checking whether port 1433 is enabled is as follows:

Start –> input cmd–> Enter –>telnet localhost 1433-> A black screen appears in the carriage return, indicating that the native connection port 1433 successfully .


Start –> input cmd–> Enter –>netstat-an | find "1433" enter 1433 port to indicate that the native 1433 port is open.

I encountered a problem during the installation process: Port 1433 is not enabled.

System environment: Windows Server R2

SQL version: Microsoft SQL Server R2

1, completely new installation of SQL Server2008, delivery research and development use. Research and development feedback, database connection is not up. The following error is reported:

650) this.width=650; "title=" 1.jpg "src=" Http:// " alt= "Wkiol1nxx4zwoviraajresymwbu884.jpg"/>

2. View both the SQL Server service and the TCP/IP protocol are turned on.

3. Use " start –> input cmd–> Enter –>netstat-an | find" 1433 " Enter ", did not see the IPv4 1433 port open, and see IPv6 1433 Open, also thought is IPv6 reason. Uninstalling the IPV6 is still not working.

4. Modify the TCP port in TCP/IP in SQL Server configuration Manager under SQL Server network configurations.

650) this.width=650; "title=" 2.jpg "src=" Http:// " alt= "Wkiol1nxymecgvhjaagi_xdlqwe163.jpg"/>

The original, such as, TCP port no port number, plus 1433 is not resolved.

5, the last reference on the Internet other methods, in fact, the above operation from the problem solved already very close. Recently modified places, such as:

650) this.width=650; "title=" 2014-05-08_sql08 in Windows server2008 1433 ports not up and serviced solution. jpg "src="/HTTP/ "alt=" Wkiom1nxycpcxz-4aap4y_9bkns173.jpg "/>

is to modify the "TCP port" in "IPALL" to 1433. The problem is resolved.


This article is from the "Flying Pig" blog, please be sure to keep this source

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.