Is Analysis Services included in SQL Server 2016 Standard edition?

Question

Is Analysis Services included in SQL Server 2016 Standard edition?

Eric Mamet

SSChampion

Points: 11728
More actions
August 28, 2016 at 8:39 am

#329688

A colleague told me that there is Analysis Services in SQL Server 2016 standard edition, though with capacity limits.
Is that true?
Or is it still necessary to get Enterprise edition?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246956 More actions · Answer 1

Eric Mamet (8/28/2016)
A colleague told me that there is Analysis Services in SQL Server 2016 standard edition, though with capacity limits.
Is that true?
Or is it still necessary to get Enterprise edition?

It's true. Take a look here for a bit more detail.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Eric Mamet SSChampion Points: 11728 More actions · Answer 2

This is brilliant for small businesses!

Is it new in 2016, or did I miss it in 2014?

I am still using 2012...

Sue_H SSC Guru Points: 90860 More actions · Answer 3

Is it new in 2016, or did I miss it in 2014?
I am still using 2012...

Not new, available on Standard with previous versions as well. In the link you were referred to, look at the top under the title and there is a drop down where you can select other versions.

Sue

Eric Mamet SSChampion Points: 11728 More actions · Answer 4

In 2014, there was no Tabular with Standard Edition, however you got it with "Business Intelligence" edition, which seems to have disappeared in 2016.

And in 2016 Standard Edition, we don't have "perspectives"...

Interesting...

Thanks for the links and remarks

Eric

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Eric Mamet (8/28/2016)
This is brilliant for small businesses!
Is it new in 2016, or did I miss it in 2014?

It's been like this since there was an Analysis Services (SQL 2000? SQL 7?)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Sue_H SSC Guru Points: 90860 More actions · Answer 6

Eric Mamet (8/28/2016)
In 2014, there was no Tabular with Standard Edition, however you got it with "Business Intelligence" edition, which seems to have disappeared in 2016.
And in 2016 Standard Edition, we don't have "perspectives"...
Interesting...
Thanks for the links and remarks
Eric

With the release of SQL Server 2016, Microsoft removed the BI Edition edition.

Sue