Share via

sqlserver2019 configuration report server error

Richard 1 Reputation point
2021-12-10T04:42:14.463+00:00

156388-image.png

156522-image.png

156523-image.png

156378-image.png

I installed the report server on the sqlserver2019 server, and when I created the database, this error was reported. How can I troubleshoot? Please help guide

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.


1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,651 Reputation points
    2021-12-10T06:48:04.143+00:00

    Hi @Richard ,
    I want to confirm whether you created a new report server database or selected an existing report server database when configuring the report server. I assume you choose an existing report server database. Does the sql server engine hosting the database of the report server exist locally? We know that SQL Server is used to host the report server database. The SQL Server database engine instance can be a local or remote instance.

    When you create a report server database, not all editions of SQL Server can be used to host the database. For more information, see Edition requirements for the report server database in SQL Server Reporting Services features supported by its editions.

    In addition, please make sure that the editions of the sql server and report server are consistent. The editions of the report server and the backend sql database need to match. e.g. Developer Edition for RS on Developer Edition for SQL.
    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.

    Was this answer helpful?

    0 comments No comments

Your answer

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