When input an error instance name and right port number of sql server 2016, still connect successfully

The instance name is ignored when you connect using a port number. It is irrelevant since you have pointed to which instance to connect to using the port number. Never specify an instance name when you connect using a port number, it is only confusing - as you just have experienced.

I would have preferred if MS decided to catch this as an error and gave us an error message when it detects a backslash and a comma (i.e., when we try to use both).

Hi @Rocky Shi ,

That is not one error, there are many connecting methods.

There can be multiple SQL Server instances on a server, and you can specify multiple port numbers for an instance, and each instance uses a different port number. When you use the port number to connect, IP and Port numner are its unique identification.

More information :configure-a-server-to-listen-on-a-specific-tcp-port

BR,
Mia

If the answer is helpful, please click "Accept Answer" and upvote it.

Hi @Rocky Shi ,

Is the reply helpful?

BR,
Mia

If the answer is helpful, please click "Accept Answer" and upvote it.

Hi @Rocky Shi ,

Is the reply helpful?

BR,
Mia