Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I just installed sql server 2008 developer edition on my windows vista machine. The installation was successful. Reporting service is working fine. But I am not getting any option to connect to "Analysis Services" in sql management studio.

The only options i get for "Server Type" while connecting are -

1. Database Engine
2. Sql Server Compact

Pls. suggest. Thanks.

share|improve this question
Stupid question: did you install Analysis Services? Is it running in the list of Windows Services? – user3914 Jun 20 '10 at 5:00
@Radolph Potter: Yes, I did install it. Also I can see the service running in the services.msc window. – user46277 Jun 20 '10 at 5:18
up vote 3 down vote accepted

I think you must have installed Management Studio with only the Basic option selected. You need to install the "Complete" option in order to have support for Analysis Services. You should be able to just add the feature through the installer.

alt text

share|improve this answer
Thanks a lot. That was the issue :) – user46277 Jun 22 '10 at 17:18
If that doesn't work, then this did for… – Rikalous Aug 31 '12 at 16:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.