SQL Cluster Port# Change
Posted on 2009-05-07
We are running SQL 2005 Failover cluster with 2 active nodes and 1 passive. The active nodes have a default instance and 2 named instances on one active Node and 3 named instances on the other active Node. I noticed that in addition to the default intance running on 1433 (which is the 'default' for a default instance), 3 other instances have been set up use static port of 1433. Should the named instances be using port 1433? I need to modify another named instance to a static port #... what port numbers should I be using? Should I use 1433 again? Thank you.