Installing Failover Clustering

If you are installing Microsoft® SQL Server™ 2000 failover clustering on Microsoft Windows NT® 4.0, Enterprise Edition, you need to install programs in the order specified below. However, this is not necessary if you are installing failover clustering on Microsoft Windows® 2000 Advanced Server or Windows 2000 Datacenter Server.

Caution  If you do not install the programs in the following order, the software products can fail on installation and require that you completely reinitialize the disk and restart installation.

Before installing SQL Server 2000 in a failover cluster configuration, you must upgrade any pre-release versions of SQL Server 2000.

To install failover clustering on Windows NT 4.0

1. Install Windows NT 4.0, Enterprise Edition.

   Windows NT 4.0, Enterprise Edition includes Windows NT 4.0 Service Pack 3. Service Pack 3 is required to install Microsoft Cluster Service (MSCS).

   • Do not go directly to Service Pack 4 or later if you intend to install the Windows NT Option Pack.
     
     
   • Do not install Microsoft Internet Information Server (IIS).

   Important  IIS is installed by default. It is recommended that you clear this option during the Windows NT 4.0 installation.

2. Install MSCS.
   
   
3. Install Microsoft Internet Explorer version 5.0 or later.
   
   
4. Manually create a Microsoft Distributed Transaction Coordinator (MS DTC) compatible resource group where MS DTC setup can create its resources. This should contain an IP address, network name, and cluster disk resource. Any group with these three things is compatible with MS DTC.

   SQL Server Setup will install MS DTC in a later step. Install Windows NT 4.0 Option Pack only if you require components of the Windows NT 4.0 Option pack besides MS DTC.

5. Install the latest Windows NT 4.0 Service Pack, Service Pack 5 at the latest. Click Create an uninstall directory, click Year 2000 Setup, and then select the Service Pack install for Intel based systems check box.

   Do not select Microsoft Message Queue Server (MSMQ 1.0) or IIS. MSMQ 1.0 is not supported on SQL Server 2000. It is recommended that IIS functionality be used with Windows NT Load Balancing Service (WLBS). For more information about WLBS, search on "WLBS Features Overview" on the NT Server Microsoft Web site.

   Prior to Step 5, it is recommended that you rename the hidden directory $NTServicePackUninstall$ to $NTServicePackUninstall$.service packnumber. After installing the service pack, add a new directory. This way you have uninstall directories available, which prevents the directories from being accidentally overwritten.

6. Install SQL Server 2000.

Note  Install any additional server products before installing any other applications.

To install failover clustering on Windows 2000

1. Install Windows 2000 and accept the default application choices.
   
   
2. After installing Windows 2000 on the first node and prior to installing MSCS, click Start\Programs\Administrative Tools\Configure Your Server.
   
   
3. Click Advanced\Cluster Service, and then in the right pane, click Learn More.
   
   
4. From Help, review Item 2 under Windows Clustering.

   Windows Clustering is used during the installation of Windows 2000 and with SQL Server 2000 failover clustering. Follow these instructions to install MSCS.

   Important  It is necessary to read the section on Planning for Windows Clustering\Requirements for server clusters and to follow the Checklist for server clusters called Checklist: Creating a server cluster. This is found under the Server Clusters section\Checklist for server clusters.

5. After you have successfully installed MSCS, you need to configure MS DTC to run on a cluster.

   For more information about MS DTC, see Failover Clustering Dependencies.

6. On the Start menu, point to Programs\Administrative Tools\Cluster Administrator, and click View Groups\Cluster Group. If the group contains an MS DTC resource, proceed to Step 9. If not, complete the following two steps.
   
   
7. On the Start menu, point to Command Prompt. Enter comclust.exe from the command prompt.
   
   
8. Repeat Step 7 on the remaining nodes of the cluster, one node at a time.
   
   
9. Install SQL Server 2000.

Note  Install any additional server products before installing any user applications.