SQLTeam.com | Weblogs | Forums

Connecting to SQL server with any name


#1

Hello,
We have a Production server setup with Availability Group, name like ProdServer,31101
we are able to connect to that server with any name like ProdServer,31101\Test
ProdServer,31101\dba
ProdServer,31101\host

Does it make any sense, Do anyone have idea about this. how does it work?


#2

I am seeing the same behavior.

My conjecture is that it is something that is used for informational purposes. Also, it allows you to connecti to the same instance/same port/same user more than once from the same SSMS instance.

Emphasis on "conjecture" , so if there are other characteristics for the string that follows the port, I stand corrected.