CODEWITHSUNDEEP
sql-server-2008ssasssms
csg
csg

Reputation: 2107

How to connect to SSAS instance from SSMS?

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.

The problem is that I dont see it in databases list with 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.

Upvotes: 1

Views: 2729

Answers (1)

Callie J
Callie J

Reputation: 31296

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.

Upvotes: 5

Related Questions