JSI Tip 9454. How do I cluster SQL Server 2000 Analysis Services in Windows 2000 and Windows Server 2003?

Microsoft Knowledge Base Article 308023 contains the following summary:

This article provides step-by-step instructions on how to set up SQL Server Analysis Services 2000 as a clustered service. Although Analysis Services is not a cluster aware application, you can install and configure Analysis Services as a generic service on a cluster.

When you follow the steps listed in this article, you can operate Analysis Services in a clustered environment, which provides a high availability solution for Analysis Services. The following assumptions are made for this Microsoft Knowledge Base article:

•	The cluster is running on a Microsoft Windows 2000 Advanced Server-based computer, a Windows 2000 Datacenter Server-based computer, or a Windows Server 2003-based computer.
•	The cluster group in which you configure Analysis Services always runs on the same node as the default cluster group, which contains the Cluster IP Address and Cluster Name.

Note This Microsoft Knowledge Base article refers to the node that currently has control of the cluster server virtual name, IP Address, and shared disk where you want to store your Analysis Services data files as Node1.

NoteThere are instructions for Analysis Services 64-bit installations in some sections under the "Analysis Services 64-bit installations" heading. The setup is different because Analysis Services 64-bit installations must have the repository and the query log saved on the SQL Server database. You can have two configurations for the computer that is running SQL Server that has the repository and the query log for Analysis Services 64-bit:

•	You can configure the computer that is running SQL Server that stores the repository and the query log off the cluster. This configuration is the easiest to configure for Analysis Services because you only have to make connection string changes to point to the computer that is running SQL Server.
•	You can configure the computer that is running SQL Server that stores the repository and the query log on the cluster. This configuration implies that this computer will also be clustered in an Active/Passive configuration. This configuration requires more steps for Analysis Services to be clustered.

Important SQL Server 2000 Analysis Services can only be set up for an Active/Passive configuration. Active/Active configurations of Analysis Services are not supported.

We assume the following about Analysis Services 64-bit installations:

SQL Server will be configured by using the second configuration method. SQL Server will be installed and set up as a virtual instance on the same cluster as Analysis Services before Analysis Services is installed. This virtual instance will be the only instance of SQL Server on the nodes. This instance of SQL Server is intended to store the repository and the query log for Analysis Services 64-bit.