October 21, 2015 at 5:19 am
Hi Guys,
We had two SQL Server Instances SQL Server 2008 R2 and SQL Server 2012. Let consider Instance1 as SQL Server 2008 R2 with Port 21433 and Instance2 as SQL Server 2012 with Port 21434. When I tried to connect to Instance2 with port 21433 it is connecting to Instance1 and If I connect to Instance1 with 21434 it is connecting to Instance 2.
Does anyone know why it is wrongly pointed?
Regards,
Varun R
October 21, 2015 at 5:28 am
It's not.
Instance1 is listening on port 21433
Instance2 is listening on port 21434
Hence when you connect and specify port 21433, you get Instance1, it's the instance listening on that port. Same when you connect on port 21434, you get the instance listening on port 21434, that is, Instance2
The names are like web addresses, friendly and easily memorable so that we don't have to remember the port numbers. If you supply a name and a port number, the port number takes precedence and you connect to the instance listening on that port.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply