SSRS 2019 over SQL Server 2016 Instance

• Marinovp21

  SSC Enthusiast

  Points: 176

  More actions

  February 27, 2020 at 8:35 pm

  #3729418

  Hello,

  I was wondering if such implementation is possible, can you install SSRS 2019 using the ReportServer DB hosted on a 2016 SQL Server instance?

  TIA.

• frederico_fonseca

  SSCoach

  Points: 16155

  More actions

  February 28, 2020 at 6:36 am

  #3729495

  have you read the manuals? Info is clear there.

  https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/ssrs-report-server-create-a-report-server-database?view=sql-server-ver15

• mbhurter623

  Newbie

  Points: 1

  More actions

  September 20, 2021 at 7:36 pm

  #3931281

  Marinovp21,

   

  Did you ever find out an real answer on this?  frederico_fonseca's link really does not tell me what  I need to know.

   

  Thanks!

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  September 21, 2021 at 6:54 am

  #3931364

  How does the link not give you the information you need?

  The link states that for SSRS 2019 you can use SQL 2012 or above as the platform to host the ReportServer and ReportServerTempDB databases.

   

  Database server version requirements

  SQL Server is used to host the report server databases. The SQL Server Database Engine instance can be local or remote. The following supported versions of SQL Server Database Engine can host the report server databases:

  Azure SQL Managed Instance

  SQL Server 2019

  SQL Server 2017

  SQL Server 2016 (13.x)

  SQL Server 2014 (12.x)

  SQL Server 2012 (11.x)