Installed on the cloud server SQL sever 2016 for test


Server firewall has been closed, cloud platform opened the whole IP access full port


Now my laptop and desktop computer can connect to the database instance, normal use there is no problem,

My laptop into mobile hotspot network connection, also can, (there is no limit on the network connection)

I use is: Microsoft SQL Server Management Studio 18




-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

But I use another cloud Server test, port 1433 is pass, but Microsoft SQL Server Management Studio and unable to connect,

My colleague in the home, also unable to connect,


Now don't know what reason is this? Continue to troubleshoot,

CodePudding user response:

Look at the first:
https://blog.csdn.net/yenange/article/details/50853083

In particular,
Telnet IP port
This must have to do other,

CodePudding user response:

Already in check, now my computer is can Telnet IP to the server 1433, unimpeded,

Using portqueryui. Exe tool found that other computer unable to connect to port 1434, the service will be unable to find the SQL instance,

And my computer by the tool query port 1434 can be found that SQL server instance,

Server firewall has been closed, so far, have not found where on the network access control?
(can't connect to the database computer, also can remote to the server, that is on the network, not only port 1434)

CodePudding user response:

Use a stupid way:
Directly in the Microsoft SQL Server Management Studio 18 connection tool, the Server name and port 1433

At least on a computer cannot connect before realized the connection,