SQL Server 2012 - Analysis Services is not included on the "Feature Selection" screen of the installer

Emad-ud-deen picture Emad-ud-deen · Apr 24, 2012 · Viewed 23.8k times · Source

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.

Answer

SQLMenace picture SQLMenace · Apr 24, 2012

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