Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2013-02-14 : 10:01:42
|
| 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
52326 Posts |
Posted - 2013-02-14 : 10:17:23
|
| depends on whether you want to leverage upon the latest features of SSRS available on 2012 version.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2013-02-14 : 10:49:25
|
| Thanks! And I found this on technet:http://technet.microsoft.com/en-us/library/gg492257.aspxAccording 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 |
|
|
|
|
|
|
Which version of SSRS fits better?