Cluster SQL 2000

My cu has the Win2003 Cluster 4 nodes with 1 Default and 3 Named instances
SQL 2000, each instance is on different node, we noticed that every
instances have configured with TCP port 1433.
Is it possible on Cluster?
Hello.K
Since SQL uses 1433 as the default port and each instance sounds like its
running on its own node, I would say yes?
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"kersob" <lkm> wrote in message
news:ODcWDPdWEHA.3016@.tk2msftngp13.phx.gbl...
> My cu has the Win2003 Cluster 4 nodes with 1 Default and 3 Named instances
> SQL 2000, each instance is on different node, we noticed that every
> instances have configured with TCP port 1433.
> Is it possible on Cluster?
>
> Hello.K
>
|||Host nodes don't have anything to do with port numbers. Notice that each
SQL resource group (virtual server) has its own IP address and network name.
Therefore, you can have each instance on 1433 if you desire. HOWEVER, there
are some gotchas. If you are hoping to connect to VirtualServername rather
than VirtualServerName\InstanceName, it won't work with anything higher than
MDAC 2.6. Even if you put a named instance on 1433, the client library
'knows' it isn't the default instance. MDAC will report an error that you
are connecting to the wrong instance.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"kersob" <lkm> wrote in message
news:ODcWDPdWEHA.3016@.tk2msftngp13.phx.gbl...
> My cu has the Win2003 Cluster 4 nodes with 1 Default and 3 Named instances
> SQL 2000, each instance is on different node, we noticed that every
> instances have configured with TCP port 1433.
> Is it possible on Cluster?
>
> Hello.K
>