What Is The Minimum Version Of SQL Server 2008 For SSAS, SSRS, SSIS

Question

What Is The Minimum Version Of SQL Server 2008 For SSAS, SSRS, SSIS

winston.snyder

Say Hey Kid

Points: 667
More actions
February 14, 2011 at 7:14 am

#231291

Hi all,
What is the correct and smallest recommended version of SQL Server 2008 to install?
I would like to work with SSAS, SSRS, and SSIS with Adventureworks database
Thanks,
w

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

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

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

http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

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

winston.snyder Say Hey Kid Points: 667 More actions · Answer 2

Thanks Gail,

It appears this is the only trial Microsoft offers for SQL Server 2008

http://technet.microsoft.com/en-us/evalcenter/ee315247.aspx

I do not see in the description if this is Enterprise or Standard?

It appears from the link that I need Enterprise for MDX Queries?

Is this true if the queries are written from other application such as Excel VBA\VSTO

or MDX Studio? http://www.mosha.com/msolap/mdxstudio.htm

Kind regards,

w

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

Evaluation is Enterprise edition.

You could always spend around $60 and get a copy of developer. Full enterprise features, no expiry, licensed only for development.

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

winston.snyder Say Hey Kid Points: 667 More actions · Answer 4

winston.snyder

Say Hey Kid

Points: 667

February 14, 2011 at 2:23 pm

#1286750

Thanks Gail,

Appreciate the great info

Kind regards,

w

happycat59 One Orange Chip Points: 29389 More actions · Answer 5

You can use MDX against Analysis Services in any of Standard, Enterprise, Evaluation or Developer editions. Not all features are available in standard edition but this shouldn't affect you if you are using any of the other editions.