• tcronin 95651 (7/22/2014)


    I have two reporting services environments. First one is a native running on the same sql 2008r2 box using the 2008r2 box for it's backend. The box is a monster 256 gig or RAM and 64 core. The other box I have is a 2008 server running reporting server on same box as SQL Server backend also hosting Sharepoint. The share point is 2007 and this reporing server is running sharepoint integrated mode. For licensing reasons I was going to move the 2nd instance of reporting server (2008 version), which is lightly used and move it to the same box as a 2nd instance and governor it (all of this is enterprise edition). Does this seem feasible. From a performance standpoint I can stand up the 2nd instance pretty easily without impact. More of and issue of sharepoint configuration time than anything.

    THanks

    from a licensing perspective, I do not think that what you are planning will actually change anything unless you are planning to completely remove SSRS from the SharePoint server. That assumes that the configuration and content databases for SharePoint 2007 are on the SharePoint server.

    This also assumes that you are "happy" that the new instance of SSRS does not need to be integrated with SharePoint.