alanspeckman (8/13/2012)
Thank you all for reading and thank you Perry for your replies. 🙂 Great community here.One last question.
Is it possible for 2 SQL Server instances running on the same server to share the same port? I have tested this and it isn't possible from what I have tested so far.
Is it possible?
No, they would need a separate IP address stacked on the NIC or a totally separate NIC
For example if i have a server with a single NIC, i have 2 IP addresses stacked as
10.10.10.41 255.255.255.0
10.10.10.42 255.255.255.0
i could then set one instance to listen on
10.10.10.41, 1433
and another on
10.10.10.42, 1433
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉