Sql-server – unable to connect to sql server analysis services on windows vista

sql serversql-server-2008ssms

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.

Best Answer

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