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.
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.
Is this because Analysis Services are not available in the express version?
Best Answer
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.