Search code examples
sql-serverreporting-servicesssrs-2014

Migrating report server database from 2008R2 to 2016 while reporting service is running on SQL2014


I have SQL reporting service running on SQL 2014 version while reporting database is configured on SQL 2008R2. I am planning to migrate SQL 2008R2 to SQL 2016 so I'll move report server database to new 2016 server while reporting service will be continue to run on SQL 2014. Would there be any issue/concerns if report server database is running on SQL 2016 while reporting service is running SQL 2014?


Solution

  • Following document for SQL Server 2014: Create a Report Server Database states that it is not supported.

    SQL Server is used to host the report server databases. The SQL Server Database Engine instance can be a local or remote instance. The following are the supported versions of SQL Server Database Engine that can be used to host the report server databases:
    SQL Server 2014
    SQL Server 2012
    SQL Server 2008 R2
    SQL Server 2008
    SQL Server 2005