4.1.0 HP PolyServe Software for Microsoft SQL Server administration guide (T5392-96074, October 2010)

6 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.
HP PolyServe Software for Microsoft SQL Server 4.1 administration guide 99