Article ID: 2429685 - View products that this article applies to.
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:
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.
Contact us for more help
Connect with Answer Desk for expert help.