Newbe Question - How to install SQL 2000 Cluster

Good day,
I'm looking for a document that shows the steps needed in order to install
SQL 2000 on a windows 2003 cluster.
Thanks in advance
Oren Zippori
Great webcast on the subject:
http://support.microsoft.com/default...lurb061002.asp
http://www.sql-server-performance.co...stall_main.asp
has great information for Windows 2000, just add Q817064 and then 301600 for
MSDTC support and you are good to go.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Oren Zippori" <orenzp@.hotmail.com> wrote in message
news:ezlb3woxEHA.3416@.TK2MSFTNGP09.phx.gbl...
> Good day,
> I'm looking for a document that shows the steps needed in order to install
> SQL 2000 on a windows 2003 cluster.
> Thanks in advance
> Oren Zippori
>
|||Thanks for the Info Rodney.
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%238D7pMpxEHA.2540@.TK2MSFTNGP15.phx.gbl...
> Great webcast on the subject:
> http://support.microsoft.com/default...lurb061002.asp
> http://www.sql-server-performance.co...stall_main.asp
> has great information for Windows 2000, just add Q817064 and then 301600
> for MSDTC support and you are good to go.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
> "Oren Zippori" <orenzp@.hotmail.com> wrote in message
> news:ezlb3woxEHA.3416@.TK2MSFTNGP09.phx.gbl...
>

Newb question regarding cluster load balancing

Hello to all,
I am currently working on creating a Windows 2003 server cluster (3 nodes)
with the intent that it serve our web app which requires multiple SQL
databases. The question I have is this: How can I configure load balancing
for this? It seems that clustering services only allows 1 of the nodes to
access the DB at any given time (which is logical). If this is true, how
will I be able to leverage the processing power of the other two nodes if
they are idle while the node that is hosting the DB does all the work?
Any help would be appreciated.
Michael
You can install multiple instances of SQL Server on a failover cluster. You
cannot natively load-balance the workload between these multiple instances.
They act as independent SQL servers. SQL Clustering is a failover
technology and does not natively load balance.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Michael Weyant" <mweyant@.themarlincompany.com> wrote in message
news:OshvlPrGGHA.312@.TK2MSFTNGP09.phx.gbl...
> Hello to all,
> I am currently working on creating a Windows 2003 server cluster (3 nodes)
> with the intent that it serve our web app which requires multiple SQL
> databases. The question I have is this: How can I configure load balancing
> for this? It seems that clustering services only allows 1 of the nodes to
> access the DB at any given time (which is logical). If this is true, how
> will I be able to leverage the processing power of the other two nodes if
> they are idle while the node that is hosting the DB does all the work?
> Any help would be appreciated.
> Michael
>
|||Thanks Geoff for the information. I thought as much but hoped otherwise.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:e9dbmVrGGHA.3856@.TK2MSFTNGP12.phx.gbl...
> You can install multiple instances of SQL Server on a failover cluster.
> You cannot natively load-balance the workload between these multiple
> instances. They act as independent SQL servers. SQL Clustering is a
> failover technology and does not natively load balance.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Michael Weyant" <mweyant@.themarlincompany.com> wrote in message
> news:OshvlPrGGHA.312@.TK2MSFTNGP09.phx.gbl...
>