SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Which version of SSRS fits better?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Hommer
Aged Yak Warrior

788 Posts

Posted - 02/14/2013 :  10:01:42  Show Profile  Reply with Quote
Hi, my dear experts,

I want to get your opinion on choosing between 2008R2 or 2012 for our new Reporting Services.

The data that needs to be reported on is in SQL 2008 R2, and have no plan of migrating to sql 2012 in near future.

On the other hand, these reports will be consumed through SharePoint 2013 and SQL server 2012 (as the SP database).

So I have the option of either using sql 08 R2 or sql 2012 as my report server.

There is no right/wrong answer, I think. But from your experiences, which way is better?

Thank you and happy Valentine's Day!

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 02/14/2013 :  10:17:23  Show Profile  Reply with Quote
depends on whether you want to leverage upon the latest features of SSRS available on 2012 version.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Hommer
Aged Yak Warrior

788 Posts

Posted - 02/14/2013 :  10:49:25  Show Profile  Reply with Quote
Thanks! And I found this on technet:

http://technet.microsoft.com/en-us/library/gg492257.aspx

According to it, only sql server 2012 SP1 can feed to SP2013, or the combination is not "supported"!

Then, what are the practical considerations between sql 2012 reporting server and 2008 R2 data store...

All about match making.

-------------

Supported Combinations

Report server
Add-in
SharePoint version

1
SQL Server 2012 SP1
SQL Server 2012 SP1
SharePoint 2013

2
SQL Server 2012 SP1
SQL Server 2012 SP1
SharePoint 2010

3
SQL Server 2012
SQL Server 2012
SharePoint 2010

4
SQL Server 2008 R2
SQL Server 2012
SharePoint 2010

5
SQL Server 2008
SQL Server 2012
SharePoint 2010

6
SQL Server 2008 R2
SQL Server 2008 R2
SharePoint 2010

7
SQL Server 2008 R2
SQL Server 2008 SP2
SharePoint 2007

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000