Unable to telnet to port 1433 in SQL Server clustered instance? Situation: I believe that multiple port 1433 can be implemented as long as the IP address are all unique.
I’ve created SQL Server 2008 R2 SP1 clustered virtual instance on top of my Windows Server 2008 R2 SP1 Enterprise MSCS, one instance is working fine and I can perform:
C:\telnet SQLClustername-instance1 1433
successfully
However with the other instance I cannot perform the above command and it is not accessible at all ? pinging the SQLClustername-instance2 is fine and reply back, when I do the following command:
C:\netstat –ano | find /I “1433”
I cannot see the SQLClustername-instance2 IP address with port 1433 listening ?
Any assistance would be greatly appreciated.
Thanks.
Does the SQL Server instance installed on the cluster resource named SQLclustername-instance2 listen on port 1433? If you installed a named instance then is very likely using dynamic ports. See Configure a Server to Listen on a Specific TCP Port.