The SQL Server port is not open and is not connected to the workaround

Source: Internet
Author: User
Tags server port

Today, the manager assigned a task to check why SQL Server on the server is not connected to the problem, I have never used SQL Server before. First remote to the server on the machine, according to the online tutorial made a pass, no eggs. Just put SQL Server reinstall, and then first Use Window authentication method on the server to log on, set the port open port what, open the Port method on the network said a lot, summed up is the following several things:

1. Open the SQL Server Configuration Manager Check chart whether these two items are in the running state

2. Then check whether the two are enabled, I tried many times before, has been only the TCP/IP is enabled, has not been, and later in a post see also to the name pipes set to enable, I changed a bit, and then good, But I don't know if it's because of this, it's all set up anyway.

3. Then double-click the ECP/IP option to enter the Properties page, fill the IP address into the server's address, TCP Dynamic ports 0, TCP port set to 1433, and set to 1433 as if the default port of SQL Server is 1433 or something.

Then scroll to the bottom, the TCP port of the Ipall tab is also set to 1433,TCP dynamic port, which is automatically set

Then turn off the TCP/IP properties, open the following option, according to the image settings, and set this to 1433

Then go to the Control Panel--and the system and security--and the service, the services, to restart the two services (it is important to hear).

Write here today, it is already 10 o'clock, I have to take the subway home, I enjoy working late at night to go home to sit on the subway moment, feel pretty warm, and then write tomorrow

The SQL Server port is not open and is not connected to the workaround

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: info-contact@alibabacloud.com 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.