Bill (fluffydeadangel) (3/28/2013)
in our clustered environment, under sql server config, we set our IP's (we have 3 per box) in as normal... and we set IPAll to show port 1433. so exactly where the above poster mentioned is where we set our TCP Port and yes we use static IPs. we leave 1433, 1434 open and 5022 on mirrored databases.
When you did your installation of the Clustered SQL Instances, did they default to using Dynamic Ports, and you had to manually change them to use static ports, then set each one to 1433?
If so, I guess I just don't understand why SQL would default to dynamic ports when doing a Cluster installation? Is this the normal behavior? Again, my three Clustered Instances each has its own static IP address and it is a Named Instance, so I thought it would just install using the default port.
<baffled>:w00t:</baffled>