3

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.

user46277
  • 133
  • 1
  • 1
  • 4
  • Stupid question: did you install Analysis Services? Is it running in the list of Windows Services? –  Jun 20 '10 at 05: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 05:18

1 Answers1

3

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 http://lh6.ggpht.com/kendal.vandyke/SM3LPgl2lnI/AAAAAAAAARo/f9m3hbY74Xk/s1600-h/image42[1].png

Brian Knight
  • 1,175
  • 2
  • 8
  • 17
  • 1
    If that doesn't work, then this did for me...http://stackoverflow.com/questions/7216482/cant-install-sql-server-2008-r2-management-tool-complete – Rikalous Aug 31 '12 at 16:03