As part of my project, we are upgrading SQL Server 2008 R2 to SQL Server 2012. We have a separate SSRS 2008 instance running on a separate machine which interact with these existing 2008 database servers and create various reports.
My architect's recommended that we just create a new VM and get SQL Server 2012 with existing Data. (You install a new environment, copy your metadata and data to the new environment, and configure the new environment to use existing content.)
He suggested that we need not to make any changes to SSRS instance which is running on older version. He suggested just to re-use existing SSRS instance and point to new SQL Server 2012.
My question is about the feasibility of this solution. Will that work? Can you have SSRS instance running on older version but interacting with migrated SQL Db Server 2012 instance. Any challenges/possible issues?