How to: Install Analysis Services on a Failover Cluster

SQL Server Setup

You can install Microsoft SQL Server 2005 Analysis Services (SSAS) on a failover cluster that benefits from Microsoft Cluster Service (MSCS) to provide superior reliability.

Important:
This topic and the other Analysis Services installation how-to topics in this section focus only on installation options that are specific to Analysis Services. However, these topics provide links to other topics for more information about installation of SQL Server.

Note:
The SQL Server 2005 Analysis Services (SSAS) Instance Rename tool is not supported for use in a cluster environment.

To install Analysis Services on a failover cluster

  1. Before you start installation, review Installing SQL Server Analysis Services by Using Setup to understand the options that are specific to Analysis Services that you will have to select during Setup.

  2. Review the information and complete the prerequisites that are specific to cluster installation, described in How to: Create a New SQL Server 2005 Failover Cluster (Setup). Be prepared to provide a virtual server instance name and IP address for the clustered Analysis Services installation that is unique and distinct from the names and IP addresses of the cluster itself and from the nodes in the cluster.

  3. The steps to install SQL Server 2005 Analysis Services on a failover cluster, and the pages of the SQL Server Installation Wizard that are specific to a cluster installation, are the same for Analysis Services as for the SQL Server 2005 Database Engine. Follow the steps described in How to: Create a New SQL Server 2005 Failover Cluster (Setup) to run the Installation Wizard. Make selections that are appropriate for Analysis Services on the Components to Install, Instance Name, Service Account, and Collation Settings pages, as discussed in Installing SQL Server Analysis Services by Using Setup.

See Also