none
Project Server 2010 with SSRS 2012 ? RRS feed

  • Question

  • I have posted this question in Administration Forum as well but not getting any response there so posting here again, hoping some one will share thoughts on this.

    Question :

    We have project server 2010 with SQL server 2008R2 on Windows server 2008 R2. SSRS 2008 R2 is configures in SP Integrated mode.

    Is it possible to upgrade only Reporting Piece (SSRS) to 2012? I can do it if it’s in native mode but wonder if this can be done in SP Integrated mode?  What else it will break if I try to do this? Thoughts?

    Will i get Reporting as Shared service under Manager Service applications after upgrading SSRS to 2012 ?

     Will there be any effect on license cost?

    Wonder why? Just to explore new capabilities in 2012 reporting.

    Thanks.

    Tuesday, November 19, 2013 4:52 PM

Answers

All replies

  • Hello,

    We have project server 2010 with SQL server 2008R2 on Windows server 2008 R2. SSRS 2008 R2 is configures in SP Integrated mode.

    Is it possible to upgrade only Reporting Piece (SSRS) to 2012? I can do it if it’s in native mode but wonder if this can be done in SP Integrated mode?  What else it will break if I try to do this? Thoughts?

     It will look like Project server 2010 running with SQL Server DB engine 2008 R2 and SSRS 2012?

    Will there be any effect on license cost?

    Wonder why? Just to explore if there is something new in 2012 reporting.


    Tuesday, November 19, 2013 4:12 AM
  • I find the answer for this.In case some one is looking for this info,  It is doable to only upgrade SSRS to 2012 in project server 2010 environment leaving SQL DB engine to 2008.

    Licensing will also be the same as it was in 201o model.

    With SQL server 2012 you get the reporting services Service Application as shared application in SharePoint 2010 Central Administration. Report Server configuration is not needed for SharePoint mode configuration.

    Tuesday, November 19, 2013 6:34 PM
  • Hello,

    For benefits of SSRS 2012 see: http://technet.microsoft.com/en-us/library/ms170438.aspx

    You will need a SQL Server 2012 license for SSRS 2012.

    I would test this upgrade on a replica non production farm first.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Tuesday, November 19, 2013 7:44 PM
    Moderator