Turned out to be no problem, I don't know from which day, my computer can't even the remote database server

My computer can ping 192.168.10.201 database server (SQL2012), Telnet 192.168.10.201 1433 also, but I used to manager (SSMS2012) even not on the 10.201 database server,
Local SQL connection, whether or 127.0.0.1 is allowed, but not with a specific IP,

Colleagues used (2012) manager can even on the database server, server is essentially no problem,

I tried it again on my computer, Navicat can even 10.201 on the database server,

Server and my computer's SQL server brower are open,

Then the TCP/IP and named pipes are enabled,

Now: if the link is the default port database, an error:


Links to a non-default port database, an error:

Reshipment SSMS last night doesn't work, then all kinds of online query, fiddling to 3 o 'clock in the morning, so suddenly, which to think about it

CodePudding user response:

Port is the ID: port number, not a comma

CodePudding user response:

https://blog.csdn.net/yenange/article/details/50853083

Let's look at this,

CodePudding user response:

Still more clear I wrote above, other people's computer is essentially SSMS are connected to the server, and my SSMS even, explain the problem in my here, you provide the document on server Settings, no problem, I also wrote, Telnet and ping are general,

Navicat tool on my computer can connect server is essentially, is not SSMS

CodePudding user response:

Still more clear I wrote above, other people's computer is essentially SSMS are connected to the server, and my SSMS even, explain the problem in my here, you provide web site about the server Settings, no problem, I also wrote, Telnet and ping are general,

Navicat tool on my computer can connect server is essentially, is not SSMS

CodePudding user response:

Verymissu

reference 4 floor response:

still more clear I wrote above, other people's computer is essentially SSMS are connected to the server, and my SSMS even, explain the problem in my here, you provide web site about the server Settings, no problem, I also wrote, Telnet and ping are general,

Navicat tool on my computer can connect server is essentially, just not that SSMS

Reshipment SSMS