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
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 ?
I believe that the MSCS cluster can supports multiple SQL DB instance as long as the IP address is unique therefore port 1433 can be opened multiple times.
Any assistance would be greatly appreciated.