Is it possible to have an application running on an SQL server version different than the SSRS server version ?

Mohamed Khaled 0 Reputation points
2023-04-26T22:11:33.6366667+00:00

Is it possible to have an application running on an SQL server version different than the SSRS server version ?

Also for the report viewer, does it related to the SSRS version the application is using ? Or are they totally separate ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,079 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,849 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,341 Reputation points Microsoft Vendor
    2023-04-27T02:08:33.3633333+00:00

    Hi @Mohamed Khaled

    What are your SQL server and SSRS versions? You can host a report server database on a different version of SQL Server. In general, you can run a version of SSRS and host the database on a lower version of SQL Server.

    For the version of Report Viewer, you can check this link: https://learn.microsoft.com/en-us/sql/reporting-services/application-integration/reportviewer-controls-support?view=sql-server-ver16.

    Best regards,

    Aniya