Share via

Install SQL reporting service

derek chan 1 Reputation point
2023-12-12T04:42:27.29+00:00

I have a SQL 2016 enterprise server , want to re-install report service , running on windows server 2016 .

I have downloaded SQL reporting service 2022 and installed it , it pops to ask install evaluation , developer or express edition , I lost the existing SQL 2016 enterprise server license key , would advise how can I install it ?

as I know reporting service do not need license ( it includes with SQL server )

thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,870 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,822 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,326 Reputation points Microsoft Vendor
    2023-12-13T01:41:48.07+00:00

    Hi @derek chan

    The options that pop up are the free editions of SSRS.

    And if you want to install using a key, it is true that SSRS is part of the SQL Server package and does not require additional licensing if installed on the same server as the engine. But SQL Server product keys are specific to the version and edition they are targeted for. Therefore, a valid product key for SQL Server 2022 is required to install SSRS 2022.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

  2. Olaf Helper 41,021 Reputation points
    2023-12-18T10:39:43.4966667+00:00

    I lost the existing SQL 2016 enterprise server license key

    No need to have the product key for an existing installation. Run the SQL Server installation media and select the "Add feature" option, see

    https://learn.microsoft.com/en-us/sql/database-engine/install-windows/add-features-to-an-instance-of-sql-server-setup?view=sql-server-ver16

    0 comments