大网数据广告活动
数据库与应用安全

Can't connect to a named instance

· 52CE 我爱测

This article provides resolutions where you might not be able to connect to a named instance of Analysis Services that is installed on a failover cluster.

This article helps you resolve the problem where you might not be able to connect to a named instance of Analysis Services that is installed on a failover cluster.

Original product version:   SQL Server
Original KB number:   2429685

Symptoms

You might not able to connect to a named instance of Analysis Services that is installed 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 an SSAS instance on a failover cluster using a tool other than Failover Cluster Management (Cluster administrator on older Operating Systems), that SSAS instance will run as a stand-alone instance and will listen on a nondefault port resulting in connection failures from various applications.

Resolution

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

More information

An 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 doesn't change the port number of SSAS service on a cluster.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 05/09/2025
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。