Cannot connect to a named instance of a clustered analysis services

Article ID: 2429685 - View products that this article applies to.
Expand all | Collapse all

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:
  • 2466860 How to determine and change the port a SSAS instance is listening on

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2429685 - Last Review: November 19, 2010 - Revision: 1.0
APPLIES TO
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2005 Enterprise Edition
Keywords: 
KB2429685

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com