Telnet using and SQL Server connection failed

In today's work, you need to access the database on the server remotely. However, connection errors, error code is 1326. To be honest, about SQL Server cannot remotely access this problem, I have encountered N times. But every time not seriously to study what is the cause of it? Until today, I solved this problem that has encountered n many times, it is still quite tricky. In the process of solving this problem today, I have a deep understanding of the truth. "If you run into a problem, you will be tortured by it in your life." If, endure the pain of torture to solve it, then it will never dare to look for you. "It's the same in life, don't pray to live become simple, to pray oneself become power." If you encounter problems, don't give up.

Looked on the net to solve the SQL Server remote access failure of the idea, summed up a bit.

Firstly, log on to SQL Server with Windows authentication:

After logging in, set up SQL Server login account:

Set the status of the SQL account:

DB instance settings allow remote access:

Secondly, open SQL Server Configuration Manager:

Confirm that the SQL Server service is turned on:

Confirm TCP/IP open note (remote machine Access database is required for TCP/IP protocol if this is not turned on.) Nature is impossible to access remotely):

To view the port number:

The default port number for SQL Server is 1433. Note (The problem I'm having today is the port number, and when I change the port number to 1433, I can access it remotely)

Sometimes, the reason for not being able to access is that the firewall has a 1433 port number, and we need to open 1433 ports in the firewall. We can also change the default port number, but also go to the firewall to configure.

When I look at this workaround on the Internet, I see Telnet. Telnet is a member of the TCP/IP protocol, and its role is to implement remote logins. We can use the Telnet command to test whether the port of the database is available. (I'm using the Telnet command to solve today's problem.)

Encounter do not understand the problem, must be hard to learn, to delve. Technology and experience is so slowly accumulated up, really a man, practical work.