Can a SQL "virtual server" contains more than one SQL instance ?

Hi, I am new to SQL clustering.
I have a two nodes windows 2003 enterprise server in a cluster with sql 2000
enterprise server installed. Following the SQL installation screen I have
create a virtual server ( for SQL ) and installed the first sql instance
using "default" as the name .So far no problem.
But when I tried to install another instance of SQL it seems like I could
only create a new Virtual server and then name another SQLinstance (
example: Virtual server is " ProdSQL" and instance is INST1) , so it becomes
prodsql\inst1.
My question ( confusion ) is : can I create another instance using the same
Virtual server "prodsql" and install another instance "inst2" so this will
become prodsql\inst2. Is this possible and how to do it ?( Or one cluster
group can have only one virtual server can only have one single instance of
SQL ? )
Any advice appreciated.
George Norman
From BOL ("usually" your best buddy):
Multiple Instances of SQL Server on a Failover Cluster
You can run only one instance of SQL Server on each virtual server of a SQL
Server failover cluster, although you can install up to 16 virtual servers
on a failover cluster. The instance can be either a default instance or a
named instance. The virtual server looks like a single computer to
applications connecting to that instance of SQL Server. When applications
connect to the virtual server, they use the same convention as when
connecting to any instance of SQL Server; they specify the virtual server
name of the cluster and the optional instance name (only needed for named
instances): virtualservername\instancename. For more information about
clustering, see Failover Clustering Architecture.
joe.
"Norman" <GeorgeNorman@.hotmail.com> wrote in message
news:emEeoMuYFHA.3572@.TK2MSFTNGP12.phx.gbl...
> Hi, I am new to SQL clustering.
> I have a two nodes windows 2003 enterprise server in a cluster with sql
> 2000 enterprise server installed. Following the SQL installation screen I
> have create a virtual server ( for SQL ) and installed the first sql
> instance using "default" as the name .So far no problem.
> But when I tried to install another instance of SQL it seems like I could
> only create a new Virtual server and then name another SQLinstance (
> example: Virtual server is " ProdSQL" and instance is INST1) , so it
> becomes prodsql\inst1.
> My question ( confusion ) is : can I create another instance using the
> same Virtual server "prodsql" and install another instance "inst2" so this
> will become prodsql\inst2. Is this possible and how to do it ?( Or one
> cluster group can have only one virtual server can only have one single
> instance of SQL ? )
> Any advice appreciated.
> George Norman
>
|||Thanks Joe, that clears things up.
So when Microsoft said Multiple instance it means "multiple Virtual Servers
each with a single SQL instance" .
So does it also means that the Active -Active ( say between two nodes ) is
just running one Virtual server on each of the nodes to spread the work load
( and of course one of the node will control the quorum )?
George
"Joe Yong" <jyongNOSPAM@.scalabilityexperts.com> wrote in message
news:eJ6tUeuYFHA.3356@.TK2MSFTNGP15.phx.gbl...
> From BOL ("usually" your best buddy):
> Multiple Instances of SQL Server on a Failover Cluster
> You can run only one instance of SQL Server on each virtual server of a
> SQL Server failover cluster, although you can install up to 16 virtual
> servers on a failover cluster. The instance can be either a default
> instance or a named instance. The virtual server looks like a single
> computer to applications connecting to that instance of SQL Server. When
> applications connect to the virtual server, they use the same convention
> as when connecting to any instance of SQL Server; they specify the virtual
> server name of the cluster and the optional instance name (only needed for
> named instances): virtualservername\instancename. For more information
> about clustering, see Failover Clustering Architecture.
>
>
> joe.
> "Norman" <GeorgeNorman@.hotmail.com> wrote in message
> news:emEeoMuYFHA.3572@.TK2MSFTNGP12.phx.gbl...
>