Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
1  
If that doesn't work, then this did for me...stackoverflow.com/questions/7216482/… –  Rikalous Aug 31 '12 at 16:03
add comment

Your Answer

 
discard

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.