How to Install SQL Server 2000 Clustering

SQL Server 2000 clustering can add much needed reliability and fault-tolerance to a production SQL Server 2000 system. But as you might imagine, its installation and configuration is not as easy an installing SQL Server 2000 on a single server.

The purpose of this article is to show you how to install SQL Server 2000 Enterprise Edition onto a Windows 2000, two-node cluster using an Active/Passive configuration. Installing SQL Server 2000 clustering is not an easy task. It requires a good knowledge of Windows 2000, SQL Server 2000, and time.

Before you can install SQL Server 2000 Clustering, you must first create a Windows 2000 cluster. If you are not familiar with this, then you need to read this article on how to install Windows 2000 Clustering before you complete this article.

To attempt to make this major task just a little easier, this article is divided into these, step-by-step sections:

  • Preparing for SQL Server 2000 Clustering

  • Installing SQL Server 2000 Clustering

  • Installing the SQL Server 2000 Service Pack

  • Testing Your SQL Server 2000 Cluster

Each of the above steps must be completed in the above order before you can begin to use SQL Server 2000 clustering in a production environment. It is assumed that the reader of this article has a good understanding of how to install, configure, and manage Windows 2000 and SQL Server 2000. It also assumes that the reader is a local administrator of the servers on which SQL Server 2000 clustering will be installed.

To begin reading this article, start with the first section, and once you have read it, continue on with each additional section, until you have read them all.

Step #1: Preparing for SQL Server 2000 Clustering

Step #2: Installing SQL Server 2000 Clustering

Step #3: Installing the SQL Server 2000 Service Pack

Step #4: Testing Your SQL Server 2000 Cluster


No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |