You can install SQL Server 2005 Enterprise Edition or SQL
Server 2005 Standard Edition to support failover clustering. The following table compares the two different editions when you install Analysis Services on a failover cluster.
Collapse this tableExpand this table
Edition of SQL Server 2005
Supported instances of SQL Server 2005 Analysis Services
SQL Server 2005 Enterprise Edition
SQL Server 2005 Enterprise Edition supports many nodes as the underlying operating system supports.
For example, if you install SQL Server 2005 Enterprise Edition on a failover cluster that is running Microsoft Windows Server 2003, you can add 8 nodes to the cluster.
SQL Server 2005 Standard Edition
Note All the SQL Server 64-bit editions support failover clustering.
When you install a SQL Server 2005 x64 edition, both failover clustering and
management tools are supported. When you install a SQL Server 2005 edition for
Itanium-based systems, management tools are not supported.
How to install Analysis Services on a failover cluster
You can install Analysis Services with or without SQL Server 2005 on a failover cluster. To add SQL Server 2005 Analysis Services to an existing SQL Server 2005 cluster, see the "To add components to an existing, SQL Server 2005 cluster from the command prompt" section of the following Microsoft Developer Network (MSDN) Web site:
On the Microsoft SQL Server Installation
page, the SQL Server Installation Wizard prepares to install the software. The
Installation Wizard proceeds when the preparation is completed.
On the Registration Information page,
type information in the Name and Company
boxes, and then click Next.
On the Components to Install page, click to select the Analysis Services check box and
the Create an Analysis Server failover cluster check box to
install Analysis Services on a failover cluster, and then click
You can click to select any combination of check boxes. When you
click to select the SQL Server Database Services check box or the
Analysis Services check box, if the Setup program detects that
you are installing to a cluster node, the Create a SQL Server failover
cluster check box or the Create an Analysis Server failover cluster
check box is selected.
You can choose not to install administration tools to
shorten the installation time. If you choose to install the tools, the tools
are only installed on the current cluster node.
On the Instance Name page, select a
default or named instance for your installation. If a default or named instance
is already installed and you select the existing instance for your
installation, the Setup program upgrades the existing instance and lets you install
To install a new default instance, no default instance should exist on the computer.
To install a new
named instance, click Named Instance, and then type a unique
For more information about
instance naming rules, visit the following MSDN Web site:
On the Virtual SQL Server Name page, type
a unique name for the clustered Analysis Services. This name is used to identify the failover cluster on the network. The virtual SQL Server
name must be unique on the network and must have a name that differs from the
host cluster and cluster nodes. Click
On the Virtual SQL Server Configuration
page, enter one IP address for each network that is configured for client access. For example, enter one IP address for each network on which the virtual SQL Server is
available to clients on a public (or mixed) network. Only one IP address is
allowed on each subnet.
To avoid IP address conflicts, make sure that
the IP address that is assigned to a subnet is not shared by any other
Select the network for which you want to enter an IP
address, enter the IP address, and then click Add. The IP
address and the subnet appear. Continue to enter IP addresses for each
installed network until you have populated all desired networks by using an IP
address. Then, click Next.
The Cluster Group Selection page appears.
information about virtual server configuration, visit the following MSDN Web site:
In the Available Cluster Groups list, click the group that contains the drive that you want to use for Analysis Services. If you click the group
that contains the cluster quorum resource, you receive a warning message that recommends that you do not install to the cluster quorum resource. You can also specify a
custom path for data files in the Data Files box. To
continue, click Next.
Note You can specify a custom path for data files that are used by
Analysis Services. However, you cannot specify a path for the program files.
The program files are automatically installed in the following folder:
SystemDrive:\Program Files\Microsoft SQL Server
For more information about cluster group selection, visit the
following MSDN Web site:
On the Cluster Node Configuration page,
specify the nodes to include in the virtual SQL Server. To add a node to the
virtual SQL Server, click the computer name in the Available
Nodes list, and then click Add. To remove a node from
the virtual SQL Server, click the computer name in the Selected
Nodes list, and then click Remove. Any nodes that are
unavailable appear in the Unavailable Nodes list.
To create a one-node failover cluster, only the node that will be
installed with the virtual SQL server should be listed in the Required
Node list. To continue, click Next.
more information about cluster node configuration, visit the following
MSDN Web site:
On the Remote Account Information page, specify the remote logon information by typing a username and a password for an account that has administrator rights on all nodes of the cluster. This page only appears if you are installing Analysis Services to a remote node. The credentials that you provide are only used during SQL Server setup to configure SQL Server on each node in the virtual SQL Server. This account must be a valid administrator account on all nodes of the cluster. To continue, click Next.
information about remote account information, visit the following MSDN Web site:
On the Service Accounts (Clusters) page,
specify the username, the password, and the domain name for Analysis Services accounts.
You cannot use the same account that was assigned to the cluster
For more information about cluster service accounts, visit
the following MSDN Web site:
On the Authentication Mode page, select
the authentication mode to use for your SQL Server installation. You must also
type and confirm a strong password for the System Administrator (sa) login. To
continue, click Next.
On the Collation Settings page, specify
the sorting behavior for Analysis Services. You can use one collation for SQL
Server and Analysis Services, or you can specify collations for individual
To set separate collation settings for SQL Server and for
Analysis Services, click to select the check box to customize for each service account.
After you click to select the check box, a drop-down list appears. Select a
service from the drop-down list, and then assign the collation for the service. Repeat
this step for each service. To continue, click Next.
information about collation settings, visit the following MSDN Web site:
On the Error and Usage Report Settings
page, optionally click to clear the check boxes to disable error reporting or feature
usage reporting. To continue, click Next.
On the Ready to Install page, review the
summary of features and components for your SQL Server installation. To
continue, click Install.
On the Installation Progress page, you can
monitor installation progress on individual cluster nodes by selecting a node
from the Node drop-down list. Setup progress appears for the
selected node. To view the log file for a component during installation, click
the product or the status name on the Installation Progress
On the Completing the Microsoft SQL Server
Installation Wizard page, you can view the Setup summary log by
clicking the link that is provided. To exit the SQL Server Installation
Wizard, click Finish.
If you are instructed to restart the computer, restart the
computer now. When you complete the installation, we recommend that you read
the message from the Setup program. Failure to restart any one of the specified
nodes may cause failures when you run the Setup program again.
How to verify whether the installation is successful
To verify whether Analysis Services has been successfully
installed on each cluster node, verify that all the following conditions are true:
For each cluster node, open the Cluster Administrator tool,
and then click the cluster group that you selected in step 12 in the "How to install Analysis Services on a failover cluster" section. You must find
Analysis Services listed as a resource of the cluster
For each cluster node, you
find SQL Server Analysis Services listed in the services
list when you open the Services tool.
Note We do not recommend that you perform any operation
on this service at any cluster node. You can manage the clustered Analysis
Services by using the Cluster Administrator.
For each cluster node, the Analysis Services program files
were copied to the following
SystemDrive:\Program Files\Microsoft SQL
The Analysis Services data files must be copied to a folder
that is created on the shared drive. By default, if you did not specify a custom path for
the data files, the files are copied to the following
SharedDrive:\Program Files\Microsoft SQL
SQL Server Management Studio and SQL Server Business
Intelligence Development Studio must be installed on the cluster node on which you run
the Setup program. SQL Server Management Studio and SQL Server Business
Intelligence Development Studio must not be available in the other nodes.
You can connect to the clustered Analysis Services by using
the virtual server name that you specified step 10 in the "How to install Analysis Services on a failover cluster" section.
Note Even if you install the instance of SSAS as a named instance, you
must specify the named instance as the virtual server name. You cannot use
to connect to the instance.
How to remove Analysis Services from a failover cluster
To remove the clustered Analysis Services, follow these
Insert the SQL Server 2005 installation media in the disk drive.
Note <InstanceName> represents the name of the instance of SQL Server 2005 Analysis Services that you want to remove.
You can also use Add or Remove Programs to remove an instance of SQL Server 2005 Analysis Services on a failover cluster.
When you install Analysis Services in a cluster group, you
must make sure that the status of the group is
If you run the Setup program from a terminal session, you must
make sure that other users are logged off from cluster nodes.
If the installation source files are on a network share
location, you must make sure that all the cluster nodes can access the share
You must be either a member of the Domain Admin group or
the owner of the domain group of which you want the cluster service account to be a
member. Otherwise, you may receive the following error message:
You do not have privileges to add account to the domain
groups specified for this failover cluster. Ask your domain administrator for
privileges to add new accounts to the domain groups, or log on using an account
that does have permission.