如何从 SSMS 连接到 SSAS 实例? [英] How to connect to SSAS instance from SSMS?

问题描述

我最近安装了完整的 sql server 2008(试用版)，用于研究 SSAS.我创建了一个 SSAS 项目(使用 sqlserver 商业智能工作室)，并成功部署到本地(sql server 实例所在的位置).

I have recently installed full sql server 2008 (trial version), for doing a research on SSAS. I created a SSAS project (with sqlserver business intelligence studio), deployed locally (where sql server instance is) with success.

问题是我在 SSMS 的数据库列表中没有看到它.

The problem is that I dont see it in databases list with SSMS.

是否有特殊的方式连接到 SSAS 实例?因为查看 链接文本，我看到 SSMS 在对象资源管理器中以其他结构打开.

Is there a special way to connect to SSAS instance? Because looking at link text I see SSMS opened with other structure in object explorer.

推荐答案

当您创建连接时(文件 -> 连接对象资源管理器)...只需确保 Analysis Services 在服务器类型"下拉菜单，而不是数据库引擎.

When you create a connection (File -> Connect Object Explorer) ... just make sure that Analysis Services is selected in the "Server Type" drop down, instead of Database Engine.

这篇关于如何从 SSMS 连接到 SSAS 实例?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！