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,861 questions
0 comments No comments
{count} votes

Accepted answer
  1. AniyaTang-MSFT 12,416 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 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,571 Reputation points
    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.