SQL 2019 Standard & Reporting Services Database

Rintell Technologies 21 Reputation points
2022-09-08T04:12:57.863+00:00

I am running SQL 2019 Standard and I just installed SQL 2019 Reporting Services. SRSS installed without issue but when I attempt to configure it I run into an issue when it comes to creating a new reporting database:
The database engine instance you selected is not valid for this edition of report server. Details at https://go.microsoft.com/fwlink/?Linkid=2094957.

Any ideas how to fix this? Thanks.

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,258 questions
Accepted answer
  1. AniyaTang-MSFT 3,446 Reputation points Microsoft Vendor
    2022-09-08T06:27:49.71+00:00

    Hi @Rintell Technologies
    May I know the database engine instance you are connecting to and the version of SQL 2019 Reporting Services?
    When creating a report server database, not all versions of SQL Server can be used to host the database. For Standard Edition database engine instance, SQL Server 2019 Reporting Services needs to be Evaluation and Developer edition. I recommend you to use Developer edition.
    Best regards,
    Aniya

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,381 Reputation points Microsoft Employee
    2022-09-08T06:06:58.687+00:00

    Hi @Rintell Technologies ,
    This error is a result of mismatched SKU's between the Reporting Server and the Database Engine as the message mentions. You can also look at two entries in the RS Server logs to see what it thought it hit when it performed the SKU check.

    What Edition of Report Server did you install? What Edition of the Database Engine instance to host the database did you install? You need to make sure the Editions of both are the same. For example: Reporting Service is Enterprise, SQL Server Edition is Developer. This will cause the above error. From a usability perspective, Developer edition is essentially the Enterprise product that you can use for testing. However, Reporting Services has a specific SKU check to prevent running an Enterprise version of a Report Server against a Developer or Eval version of the Storage Engine.

    238850-01.png
    Although the official documentation states: Assuming the standard edition of SSRS is installed, you can use either the Enterprise or Standard edition of the database engine to host the report server database, but you may need to pay additional license fees for different editions.
    Best Regards,
    Joy

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.