Share via

Where and how do I add the SQL license key when SQL server reporting services expire

Dennis Huston 0 Reputation points
2024-11-20T21:34:40.0933333+00:00

Our SQL 2022 reporting services stopped working. We figured out it had expired, and I must add the SQL license key. I need to know the process of adding the license key to SQL reporting services.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,063 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,944 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Michael Taylor 55,216 Reputation points
    2024-11-20T21:51:48.4533333+00:00

    SSRS is part of SQL Server, it doesn't have separate licensing and hasn't for many years. You don't buy SSRS licenses.

    How did you figure it out "had expired"? My gut instinct is that it is your SQL Server licensing. However I'm not aware of a subscription-based SQL Server licensing model (other than a trial license) either so it wouldn't just expire.

    Did you happen to upgrade your SQL Server from an older version to a newer version? If so then you'd need updated CALs to talk to SQL. If you were using a trial license of SQL then you'd need to update that instead. The instructions for doing so are given here. This would license your SQL Server instance.

  2. ZoeHui-MSFT 37,991 Reputation points
    2024-11-21T01:39:38.5133333+00:00

    Hi @Dennis Huston，

    If you have paid for SQL Server, the SSRS should be 'free' to use.

    You may need to check if your SQL Server had expired.

    For question regarding pricing / licensing please contact a Microsoft sales partner or licensing expert.

    Please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. Or you can go to Volume Licensing Service Center support. Please choose region/language and choose to call or have web. People there will help you more effectively.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments
  3. ZoeHui-MSFT 37,991 Reputation points
    2024-11-21T07:12:24.51+00:00

    Hi @Dennis Huston，

    From the image it seems that you are using 180-day trial.

    You may select @@version to have a check, if yes, you can perform a quick, in-place Edition Upgrade to enter the product key and get the standard or enterprise version.

    Also, you could check below blog for details.

    https://www.mssqltips.com/sqlservertip/7794/upgrade-sql-server-from-evaluation-edition-to-standard-or-enterprise/

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

  4. ZoeHui-MSFT 37,991 Reputation points
    2024-11-22T01:31:36.73+00:00

    Hi @Dennis Huston，

    Please check below steps, you need to run SQL Server setup.exe not the SSRS installer. User's image

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.