5

According to the information on this page I was going to add Analysis Services to our instance of SQL Server 2012 Express Advanced:

http://msdn.microsoft.com/en-us/library/ms144275.aspx

We ran the SQL Server installer and selected "Add features to an existing instance of SQL Server". On the Feature Selection screen we only noticed the following:

Instance Features
    Database Engine Services
        SQL Server Replication
        Full Text.....
    Reporting Services

Shared Features
    SQL Server Data Tools
    Documentation Components
    Management Tools - Basic
    SQL Client Connectivity SDK

Redistributable Features

The Analysis Services feature was not in this list of choices.

All help will be appreciated.

Emad-ud-deen
  • 4,734
  • 21
  • 87
  • 152

2 Answers2

7

Express doesn't support Analysis Services

See here what is supported by each version http://msdn.microsoft.com/en-us/library/cc645993.aspx

Analysis service is supported by the sql server 2012. http://msdn.microsoft.com/en-us/library/cc645993.aspx#SSAS

Jay Doshi
  • 330
  • 2
  • 5
  • 19
SQLMenace
  • 132,095
  • 25
  • 206
  • 225
3

I do not think the express editions have Analysis Services.

Daniel A. White
  • 187,200
  • 47
  • 362
  • 445
  • 1
    SQLMenace confirmed that it's not included as part of the Express edition so we upgraded to Enterprise only to find out it was also not included as well. Feature Selection screen had the same list of features. Maybe this is a bug with the installer and a way to refresh the list is needed. We really need Analysis Services but don't know where and how to get the installer to give that choice to us. All help will greatly be appreciated. – Emad-ud-deen Jul 04 '12 at 18:47
  • 1
    @Emad There is a Business Intelligence edition now that is seperate from Enterprise. – AaronLS Oct 20 '12 at 05:12
  • Thanks again for all the replies. :-) – Emad-ud-deen Oct 22 '12 at 13:03