Active Active Clustering

I am planning to install Multiple Instance SQL Server 2000 cluster (two instances) on Windows 2000 Advanced servers (two nodes). All the examples I have seen deal with Single Instance SQL Servers. What I have read that in case of a Multiple Instance ins
tallation you merely run the SQL Server setup program another time after the installation of the first virtual server is completed. I have also read that during the install you chose one of the nodes (one of the two Windows boxes) as the owner of one virt
ual SQL Server instance. Then when you run the SQL Server setup program a second time, you specify the other node as the owner of the other SQL Server virtual instance.
My question is this: where do I specify a node as the owner of a particular SQL Server instance? On the SQL Server 2000 Failover Clustering white paper, Appendix B, http://www.microsoft.com/technet/pro...x?pf=true#XSLT
section133121120120 step 10 shows a dialog box where you specify the configured nodes. Do I specify only one node as the Configured Node? Is that how I identify the node that owns the particular SQL Server instance? Or do I we identify it some other way
? Thanks.
I am sorry that I used the old terminology from SQL Server 7.0. Thanks in advance for your help.
|||You have a preferred owners list on the properties page of the resource
group. The host nodes are listed in preferred order. The actual ownership
can be changed by moving the group to a particular host. During setup, you
install SQL from the node that owns the disk resource where you intend to
put SQL. The dialog box you refer to selects the nodes that SQL is allowed
to run on. Once SQL is installed, the instance can be moved to any allowed
node.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"EY" <shafaqrahim@.hotmail.com> wrote in message
news:69BBB5B8-E23A-451F-B8FE-EAADD88A8E56@.microsoft.com...
> I am planning to install Multiple Instance SQL Server 2000 cluster (two
instances) on Windows 2000 Advanced servers (two nodes). All the examples I
have seen deal with Single Instance SQL Servers. What I have read that in
case of a Multiple Instance installation you merely run the SQL Server setup
program another time after the installation of the first virtual server is
completed. I have also read that during the install you chose one of the
nodes (one of the two Windows boxes) as the owner of one virtual SQL Server
instance. Then when you run the SQL Server setup program a second time, you
specify the other node as the owner of the other SQL Server virtual
instance.
> My question is this: where do I specify a node as the owner of a
particular SQL Server instance? On the SQL Server 2000 Failover Clustering
white paper, Appendix B,
http://www.microsoft.com/technet/pro...on133121120120
step 10 shows a dialog box where you specify the configured nodes. Do I
specify only one node as the Configured Node? Is that how I identify the
node that owns the particular SQL Server instance? Or do I we identify it
some other way? Thanks.
>
|||Thanks Mr. Hitten for answering my question so promptly.