Cannot connect to a named instance of a clustered analysis services

Symptoms

You may not able to connect to a named instance of Analysis Services that is intalled on a failover cluster. You may receive an error message that is similar to the following:


Cannot connect to <server name>

ADDITIONAL INFORMATION:

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)
------------------------------

No connection could be made because the target machine actively refused it <ip address>:2383 (System)

Cause

The problem occurs when you start the named instance of SQL Server Analysis services (SSAS) using either SQL Server Configuration Manager or the Services applet in the Control panel.
When you start a SSAS instance on a failiover cluster using a tool other than Failover Cluster Management (Cluster administrator on older Operating Sysstems), that SSAS instance will run as a stand alone instance and will listen on a non-default port resulting in connection failures from various applications. 

Resolution

Stop and restart the SQL Server Analysis services using the Failover Cluster Mangement tool.

More Information

A SSAS instance started on a cluster (default or named instance) will start listening on all IP addresses of the cluster group using the default port of 2383. The server setting <Port> property does not change the port number of SSAS service on a cluster.

For additional information refer to the following KB article:
  • 2466860How to determine and change the port a SSAS instance is listening on

Properties

Article ID: 2429685 - Last Review: Nov 19, 2010 - Revision: 1

Feedback