Installing SQL Server 2000

  • Article

Microsoft SQL Server 2000 provides improved interoperability with Windows Cluster Service. Prior to SQL Server 2000, SQL Clustering used three rebinding virtual DLLs interjected between every SQL Server or client component and the corresponding kernel DLLs. SQL Server 2000 also contains the following improvements over previous versions:

  • Clustering is much easier to manage. It is implemented through the use of SQL Instancing, which removes the need for the virtual mapping tier so that you can directly manage individual components in the cluster environment.
  • All SQL Server tools are cluster-aware, which makes the environment significantly more robust. The tools are now integrated, which eliminates the need to coordinate the use of multiple tools. Previously, when you had to use several tools to manage a cluster, any misuse or lack of coordination in using the tools could cause the cluster to fail.
  • Clusters can contain up to four nodes (instead of two as in previous versions).
  • You can now perform rolling upgrades on nodes in a Windows Cluster Service cluster. Prior to SQL Server 2000, you had to take the entire cluster offline to perform an upgrade. With SQL Server 2000, you can take just one node offline at a time to perform the upgrade, leaving the other nodes online.
  • Full-text search is now cluster aware.

Ee823365.important(en-US,CS.20).gifImportant

  • Commerce Server 2002 Data Warehouse does not support OLAP clustering.

Ee823365.note(en-US,CS.20).gif Note

  • Commerce Server does not support a mixed Microsoft SQL Server 7.0 and SQL Server 2000 configuration for the Data Warehouse and OLAP server databases.

To install SQL Server 2000 on the database tier, use the following procedure on each server in the SQL Server cluster.

To install SQL Server 2000 on the database tier

  1. If the servers running SQL Server share an external storage device (or shared-storage unit), connect and configure the device to the servers using SCSI cables (or the necessary connection equipment). For more information about this step, see the documentation accompanying your storage equipment.
  2. Install Cluster Service as instructed in the Step-by-Step Guide to Installing Cluster Service.
  3. Create a new cluster disk resource for Microsoft Distributed Transaction Coordinator (MSDTC).
  4. Configure MSDTC to run on a cluster by running the comclust.exe command.
  5. Install SQL Server 2000, specifying the appropriate options for your deployment.
  6. Enable Named Pipes using the SQL Server Client Network Utility.
  7. Install SQL Server 2000 Service Pack 2.

See Also

Clustering the SQL Servers

Deploying a Secure Site

Copyright © 2005 Microsoft Corporation.
All rights reserved.