You are currently offline, waiting for your internet to reconnect

Cannot connect to a named instance of a clustered analysis services

Extended support for SQL Server 2005 ended on April 12, 2016

If you are still running SQL Server 2005, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

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>


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)

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. 
Stop and restart the SQL Server Analysis services using the Failover Cluster Mangement tool.
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

SSAS Port; SSAS Cluster Port;
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.

Article ID: 2429685 - Last Review: 11/19/2010 16:49:00 - Revision: 1.0

Microsoft SQL Server 2008 R2 Enterprise, Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2005 Enterprise Edition

  • KB2429685