4.0.0 HP PolyServe Software for Microsoft SQL Server Administration Guide (T5392-96056, March 2010)

7 Configure SQL Server Analysis Services
Microsoft SQL Server Analysis Services (SSAS) provides online analytical processing (OLAP) and data
mining features.
This chapter describes how to configure SSAS for high availability.
Overview
Two or more cluster nodes are required to configure SSAS for high availability. In this configuration,
SSAS is accessed via a virtual host (a Virtual SSAS). One cluster node is primary for the Virtual SSAS
and the other nodes are backups. A Virtual SSAS instance and Analysis Services Service monitor is
associated with the Virtual SSAS. If the monitor detects that the SSAS NT service is down or that the
SSAS data path is not available, the Virtual SSAS can fail over to a backup node, which will continue
the SSAS operations.
Configure a Virtual SSAS
You will need to create a separate Virtual SSAS for each SQL SSAS instance that you have installed.
A Virtual SSAS includes network interfaces located on a primary node and one or more backup
nodes. The SSAS instance to be added to the Virtual SASS must exist on each of these nodes.
DNS requirement for Virtual SSAS
A DNS entry must exist for each Virtual SSAS/IP address. The entry must include an A record and a
PTR record for forward and reverse lookup. Windows authentication may fail if these records do not
exist. Be sure to create a DNS entry for each Virtual SSAS Server/IP address that you create.
Create a Virtual SSAS
To create a Virtual SSAS, start the PolyServe Management Console and then select Matrix > Add >
Add Virtual Analysis Services. The Add Virtual Analysis Services window appears.
HP PolyServe Software for Microsoft SQL Server administration guide 89