This question is in regards with SQL server 2005 and 2012.
I have a database server with two instances of SQL Server. Through SQL server management studio I was able to connect to both instances by providing "IP-Address"\"InstanceName" and user ID/password. But, I was not able to telnet the server on port 1433 from command prompt of the client PC.
Finally, when I specified TCP port 1433 through "SQL server configuration manager" on the server and restart SQL server services I was able to telnet to server on port 1433.
I want to know how "SQL server management studio" was able to make connection with SQL Server even if port 1433 was not active on SQL server? And, the sequence of activities that takes place in background when management studio initiates connection with SQL server?
Regards, Deepak Bisht