无法连接到 SQL Server Analysis Services 即使它似乎正在运行 [英] Cannot connect to SQL Server Analysis Services even though it seems to be running

问题描述

我刚刚运行了一个更新版"来从 SQL Server 2008 R2 Express 更新到 Enterprise.我先跑了更新版流程，然后单独添加了Analaysis Services组件.所有这些过程都没有报告任何错误.

I just ran an "update edition" to update from SQL Server 2008 R2 Express to Enterprise. I first ran the update edition process, and then separately added the Analaysis Services component. All these processes ran without reporting any errors.

当我打开 SQL Server 配置管理器时，我可以在SQL Server 服务"下看到 Analysis Services 正在运行.

When I open SQL Server Configuration Manager, I can see under "SQL Server Services" that Analysis Services is running.

但是，当我启动 SQL Server Management Studio 并进入连接到..."对话框时，在服务器类型"下拉列表中，我没有选择分析服务"的选项(我只得到是数据库引擎"和SQL Server Compact").这意味着我实际上无法连接到 Analysis Services 服务器，即使它似乎正在运行.

However, when I start up SQL Server Management Studio and get to the "Connect to..." dialog, in the "Server Type" dropdown I don't get the option to select "Analysis Services" (all I get is "Database Engine" and "SQL Server Compact"). This means I can't actually connect to the Analysis Services server, even though it seems to be running.

有关正在发生的事情或我需要更改哪些内容以使 Management Studio 能够查看"Analysis Services 服务器的任何建议?

Any suggestions as to what is going on, or what I need to change in order to enable Management Studio to "see" the Analysis Services server?

推荐答案

我认为 Brian Knight 可能已经在 serverfault.com 中回答了这个问题.有关详细信息，请参阅以下链接:https://serverfault.com/questions/152904/unable-to-connect-to-sql-server-analysis-services-on-windows-vista/153625#153625

I think Brian Knight might have answered this issue in serverfault.com. See the following link for more information: https://serverfault.com/questions/152904/unable-to-connect-to-sql-server-analysis-services-on-windows-vista/153625#153625

确保您已使用完整选项安装 Management Studio.基本安装选项不安装对 Analysis Services 的支持.您可以通过再次运行安装程序来添加 Management Studio 功能.我希望这会有所帮助.

Make sure you've installed Management Studio with the Full option. The basic installation option doesn't install support for Analysis Services. You can add Management Studio features by running the installer again. I hope this helps.

这篇关于无法连接到 SQL Server Analysis Services 即使它似乎正在运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！