无法连接到 SQL Server Analysis Services，即使它似乎正在运行
我刚刚运行了一个“更新版本”来从 SQL Server 2008 R2 Express 更新到 Enterprise。我首先运行更新版本过程，然后单独添加分析服务组件。所有这些进程都运行没有报告任何错误。
当我打开 SQL Server 配置管理器时，我可以在“SQL Server Services”下看到 Analysis Services 正在运行。
但是，当我启动 SQL Server Management Studio 并进入“连接到...”对话框时，在“服务器类型”下拉列表中，我没有选择“分析服务”的选项（我得到的只是“数据库”）引擎”和“SQL Server Compact”）。这意味着我实际上无法连接到 Analysis Services 服务器，即使它似乎正在运行。
关于正在发生的事情或者我需要更改什么才能使 Management Studio 能够“查看” Analysis 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.
When I open SQL Server Configuration Manager, I can see under "SQL Server Services" that Analysis Services is running.
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.
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?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我认为 Brian Knight 可能已经在 serverfault.com 上回答了这个问题。请参阅以下链接了解更多信息：https://serverfault.com/questions/152904/unable-to-connect-to-sql-server-analysis-services-on-windows-vista/153625#153625
确保您已使用“完整”选项安装 Management Studio。基本安装选项不安装对 Analysis Services 的支持。您可以通过再次运行安装程序来添加 Management Studio 功能。我希望这有帮助。
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
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.