Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like to implement SQL Server 2012 purely for the Business Intelligence Features: SSIS, SSAS and SSRS on its own server.

I current have SQL Server 2008R2 Database Engine installed on another server. It is maintained by a vendor, so it cannot be upgraded to 2012.

From what I understand within SQL Server 20102 Business Intelligence tools, you are able to use 2008R2 databases as database targets/sources. Ideally, I would like to be able to create 2012 BI Projects: SSIS, SASS, and SRSS and deploy the solutions to Sql Server 2012, but transform the data in the 2008R2 database.

Is this setup possible? If so, other than licensing are there any drawbacks or potential problems?

share|improve this question
up vote 5 down vote accepted

Perfectly reasonable proposal. No technical issues from your description of what you're aiming for.

I'm wary of commenting on licensing issues and would encourage you to verify you are correctly covered with either Microsoft or your reseller. In principle, the same licensing would apply for this arrangement as would apply if you were also deploying the database engine to that server.

share|improve this answer

You can install SSAS, SSIS and SSRS2012 and use a SQL Server 2008 R2 database as the backing data store. Assuming that the vendor will let you set up other databases on the server there is nothing that would prevent you from doing this.

However, you would have to Licence SQL Server 2012 in order to do this. If (a) you can do this and (b) the vendor will let you set up your B.I. suite and associated databases on the server then there is no technical obstacle that would prevent you from doing this.

If you wanted to put it on a separate server then you would have to license that separately.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.