How to have analysis service up and running in SQL Server Express Edition

sql sql-server sql-server-2008-r2 analysis
Kameron picture Kameron · Mar 6, 2012 · Viewed 17.8k times · Source

I am badly stuck up with this problem!

I am running Microsoft SQL Server 2008 R2 and Business Intelligence Development Studio.

I am assigned a Analysis Project.

Now it so happens that I have an express edition and I know that Express edition does not have analysis services included in it.

So my question is How do I use Analysis services?

I have spent 2 days of my life searching for the downloads of analysis services. Can anyone do the trick for me?

Answer

Remus Rusanu picture Remus Rusanu · Mar 6, 2012

SQL Server Analysis Services is available only in Standard Edition, Enterprise Edition and Datacenter Edition. See Features Supported by the Editions of SQL Server 2008 R2. You will need to buy such an product. Evaluation versions are available but you cannot deploy them in production. Developer edition is also available for you to develop the solution, but in production you need to deploy a correctly licensed Standard or Enterprise edition.

Related questions

Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)

I have a development database that re-deploy frequently from a Visual Studio Database project (via a TFS Auto Build). Sometimes when I run my build I get this error: ALTER DATABASE failed because a lock could not be placed on …

Read More
Select SQL Server database size

how can i query my sql server to only get the size of database? I used this : use "MY_DB" exec sp_spaceused I got this : database_name database_size unallocated space My_DB 17899.13 MB 5309.39 MB It returns me several …

Read More
CREATE TABLE IF NOT EXISTS equivalent in SQL Server

CREATE TABLE IF NOT EXISTS works on mysql but fails with SQL Server 2008 R2. What is the equivalent syntax?

Read More