sql-serverssas

Cannot find SQL Server Analysis Services in SQL Server 2012 Management Studio


I use SQL Server 2012 Express and SQL Server 2012 Management Studio (I don't know if both are necessary, I saw that in a tutorial) and I want to add the feature Analysis Services. I ran the Setup.exe and in "feature selection" the option Management Tools - Basic was selected. I tried to connect to Analysis Services like this:

SQL Server Management Studio -> File menu -> Connect Object Explorer -> Server type

where it is supposed to be the option Analysis Services but there is the default and unique option "Database Engine".

Can someone help me?


Solution

  • Install this completely with all features or atleast features related to analysis services Download Link