Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

My goal is to access a server with some cube data and query it. If I understand correctly I need Analysis Services in order to accomplish this.

Analysis Services greyed out

My Current install of SQL Server Management Studio as shown above does not have Analysis Services available.

When I install SQL Server 2012 express the following are the only options I have, I'm not seeing an option for management tools complete.

Only three options

Is this because Analysis Services are not available in the express version?

share|improve this question
up vote 1 down vote accepted

Yes, you only get the database engine (and a bit of Integration services as it relates to the database engine) with Express. If you want to connect to SSAS you'll need the non Express version of SSMS.

Check the Feature comparison by edition.

share|improve this answer
Thanks I had looked through the feature comparison page before but I couldn't quite Identify exactly what I was looking for. Thank you for the clarification. – Trevor May 9 '14 at 20:34

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.