Active/Active SQL Cluster

I have two new SQL 2000 instances on separate Win2K3 servers. Is there a way within W2K3 to set them up as an active/active cluster. And do I need to set it up just one one server(insert cd and it will recognize the other server to connect.
We cannot take standalone Win2K3 servers and form a cluster. We need to have a Certfied Cluster Solution listed in Microsoft Hardware Compatibility List (HCL).
A certified cluster does not consist simply of parts that individually reside on the Microsoft Hardware Compatibility List (HCL).
For example, suppose Server model S, HBA model H, storage frame F, and fibre switch W are all certified with Microsoft. This does not mean that a cluster built with S+H+F+W is supported - and customers
requiring support should not simply build a solution with these components.
Non-certified cluster solutions are not guaranteed to operate correctly. For example, the shared disks may be visible to multiple nodes and this can lead to corruption of application data or instability where the
connection to the disks is not reliable. You can waste a lot of time by attempting to troubleshoot perceived server cluster issues that are being caused by the cluster hardware that you are using.
How to locate qualified cluster solutions for Windows
http://support.microsoft.com/?id=828262
NOTE: If the cluster solution is not listed on the HCL or WSC in the Cluster category, the cluster solution is considered UNSUPPORTED. However, Microsoft PSS will offer troubleshooting tips if the customer
requests them. PSS does NOT guarantee that a resolution will be found for non-HCL or non-WSC Clusters. If no resolution is found, the incident is not refunded.
Q309395 The Microsoft Support Policy for Server Clusters and the HCL
http://support.microsoft.com/?kbid=309395
Q327518 The Microsoft Support Policy for Clustered SQL Servers
http://support.microsoft.com/?kbid=327518
Here are some links that will give a good understanding of Microsoft Cluster Server and SQL Server 2000 Failover Clustering
Support WebCast: Windows Clustering: An Overview of Microsoft Clustering Technologies
http://support.microsoft.com/?id=325423
Step-by-step instructions for creating and configuring a typical single quorum device multi-node server cluster using a shared disk on servers running the Microsoft Windows Server 2003 Enterprise Edition and
Windows Server 2003 Datacenter Edition operating systems.
http://www.microsoft.com/downloads/d...displaylang=en
Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/SQL/techinf...vercluster.asp
SQL Server 2000 Pricing and Licensing
http://www.microsoft.com/sql/howtobu...rlicensing.asp
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I have two w2k3 servers set up as active/passive cluster. Is it possible to set up an active/active cluster on the two SQL2K servers for them
"DBA" wrote:

> I have two new SQL 2000 instances on separate Win2K3 servers. Is there a way within W2K3 to set them up as an active/active cluster. And do I need to set it up just one one server(insert cd and it will recognize the other server to connect.
|||With 2000. the right terminology is single or multi instance.
Active/Active terminology doesnot apply to SQL 2000.
Yes it is possible.
"DBA" wrote:
[vbcol=seagreen]
> I have two w2k3 servers set up as active/passive cluster. Is it possible to set up an active/active cluster on the two SQL2K servers for them
> "DBA" wrote: