Clustering SQL servers

Does anyone have any information on how to link 2 separate computers with
SQL server to share the load of 1 database? [I think this is called a
cluster?]
In other words, I want to have 1 front-end application machine and 2
back-end database machines that share 1 database.
Thanks.
It might at first seem similar, but this is not really clustering;
clustering involves two or more SQL Server nodes and a shared disk array but
no load balancing. EG in an active/passive configuration the load is not
shared as, at any one time, only one SQL Server machine is in control of the
shared resource which holds the database file. For load balancing in SQL
Server 2000, there is a different technology called 'distributed partitioned
views', (in Enterprise Edition) - plenty of details in BOL.
Also, if you have a requirement to distribute processing where there is a
significant reporting element, you might want to look at having a reporting
server and using log-shipping to transfer changes from the production system
to the reporting server. In this case there is some latency involved and
your application will need to distinguish between servers for different
queries (using the 2 different connection strings).
HTH,
Paul Ibison