Can I create another one virtual SQL Server at the same cluster

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@.hotmail.com> wrote in message
news:e7jTTLJNFHA.3900@.TK2MSFTNGP10.phx.gbl...
> 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
>
>
|||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@.hotmail.com> wrote in message
news:e7jTTLJNFHA.3900@.TK2MSFTNGP10.phx.gbl...
> 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
>
>
|||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@.hotmail.com> wrote in message
news:e%23HWWUJNFHA.1096@.tk2msftngp13.phx.gbl...
> 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@.hotmail.com> wrote in message
> news:e7jTTLJNFHA.3900@.TK2MSFTNGP10.phx.gbl...
> one
> be
>
|||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@.die.spam.die.nw-america.com> wrote in
message news:u1KyWeJNFHA.3708@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> 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@.hotmail.com> wrote in message
> news:e%23HWWUJNFHA.1096@.tk2msftngp13.phx.gbl...
SQL[vbcol=seagreen]
only[vbcol=seagreen]
to[vbcol=seagreen]
new
>
|||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@.hotmail.com> wrote in message
news:O9caotJNFHA.580@.TK2MSFTNGP15.phx.gbl...
> 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@.die.spam.die.nw-america.com> wrote in
> message news:u1KyWeJNFHA.3708@.TK2MSFTNGP14.phx.gbl...
> SQL
> only
> to
> new
>
|||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@.die.spam.die.nw-america.com> wrote in
message news:ulLDR2JNFHA.688@.TK2MSFTNGP10.phx.gbl...
> Correct. Remember its a new name and IP so the ports will rename the
same.[vbcol=seagreen]
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "Peter Sun" <koarla@.hotmail.com> wrote in message
> news:O9caotJNFHA.580@.TK2MSFTNGP15.phx.gbl...
name[vbcol=seagreen]
instance.[vbcol=seagreen]
is[vbcol=seagreen]
node[vbcol=seagreen]
it
>