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

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