Hi,

I already have one virtual SQL server in the cluster, it's owned by only one
node.
Now I added another node into the cluster, and we don't want this node to be
a passive node, and don't want go to multi-instance .
So, the question is if
I can create another one virtual SQL server on the new node, give it new
SQL IP,
SQL Network Name, SQL Server...
Please advise.
Thanks you so much.

Peter

You sure can, you can have 16 instances per cluster when running on Windows
Server 2003.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog

"Koarla SUN" <koarla (AT) hotmail (DOT) com> wrote

Thank you so much, Rod !!
So, I can do the same steps on the new node to create the new virtual SQL as
what I did on the older node before.

Thanks,

Peter

"Koarla SUN" <koarla (AT) hotmail (DOT) com> wrote

Yes, only thing to watch out is that you can only have 1 default instance,
the rest are named. Or you can have all named instances, either way 16 is
the limit.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog

"Koarla SUN" <koarla (AT) hotmail (DOT) com> wrote

That's mean I had to uncheck the default box and enter the instance name in
the [Instance Name] step.

So, new virtual SQL name will be "preview default instance name\instance
name"

And I can still use the default TCP port for the new virtual SQL instance.

Thank you, Rod.

Peter


"Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in
message news:u1KyWeJNFHA.3708 (AT) TK2MSFTNGP14 (DOT) phx.gbl...

Correct. Remember its a new name and IP so the ports will rename the same.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog

"Peter Sun" <koarla (AT) hotmail (DOT) com> wrote

I was confused with the multi-instance, I was think I can go ahead to create
a another one virtual SQL server, just put these virtual SQL servers under
the same cluster.

So, I was thinking I enter a different viirtual SQL server name at the first
step, and still check default box in the [instance name} step. Then we will
have kind of virtual SQL server naming, Node1 , Node 2, ...Node 16

As I assign a new IP with the new virtual SQL server, I should be able to
use the default SQL tcp port : 1433.

I appreciate yoou got me clear.

Thank you so much.

Peter

"Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in
message news:ulLDR2JNFHA.688 (AT) TK2MSFTNGP10 (DOT) phx.gbl...