Report Server not working

Fred Schmid 6 Reputation points
2022-11-15T03:22:27.84+00:00

I have installed SQL Server 2019 Developer edition on my Windows 11 PC. And I installed Reporting Services also.
When I access the Report Server Status page of the Report Server Configuration Manager it says Report Service Status: Started".
When I try to access the Web Service URL I get "This page isn't working right now" and an HTTP Error 500.
I can access the Web Portal URL with no problems.
I setup the Service Account to use the built-account "Network Service". The Database is using the Login: NT Authority\NetworkService.
In Management Studio I cannot connect to the Report Server. I get this error message:
TITLE: Connect to Server

------------------------------

Cannot connect to MYCOMPUTER\SSRS.

------------------------------

ADDITIONAL INFORMATION:

Unable to connect to the server at MYCOMPUTER\SSRS. The specified URL might not be valid or there might be a problem with the report server version or configuration. Specify a different URL, or contact your server administrator to verify that the report server runs SQL Server 2008 or later. Additionally, if you are trying to connect to a SharePoint-integrated report server, verify that SharePoint is installed on the server and that the report server uses SharePoint integrated mode. (Microsoft.SqlServer.Management.UI.RSClient)

------------------------------

BUTTONS:

OK

------------------------------

Does anyone know what is wrong?

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

5 answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,571 Reputation points
    2022-11-15T07:18:39.977+00:00

    Hi @Anonymous
    When you open the Web Service URL and get a 500 error, you need to check if your configuration is successful. Usually you can view the error message in LogFiles, the default path is: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles. This path can be different, depending on the instance directory selected during the initial installation.
    Also make sure to provide the NETWORK SERVICE account with rwx permissions for the SSRS root folder (in my case, it was the C:\Program Files\Microsoft SQL Server Reporting Services; Properties -> Security -> Edit...).
    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.


  2. AniyaTang-MSFT 12,416 Reputation points Microsoft Vendor
    2022-11-16T08:23:05.267+00:00

    Hi @Anonymous
    According to your error message, there may be a problem with the SSRS edition. Are you using the developer edition of SSRS?
    For more details, you can refer to this link: reporting-services-features-supported-by-the-editions-of-sql-server-2016.
    Best regards,
    Aniya


  3. Fred Schmid 6 Reputation points
    2022-11-16T21:26:33.283+00:00

    261135-screenshot-20221116-041814.png

    0 comments No comments

  4. AniyaTang-MSFT 12,416 Reputation points Microsoft Vendor
    2022-11-18T07:51:50.833+00:00

    Hi @Anonymous
    I downloaded the SQL Server 2019 developer version and SSRS 2019 developer version, and configured SSRS and connected the database according to your description, but the Web Service URL works fine. Maybe you need to check if your Web Service URL is enabled or if there is an error, you can refer to this link: configure-report-server-urls-ssrs-configuration-manager.

    For SSMS unable to connect to SSRS, maybe you can refer to this link: troubleshoot-server-and-database-connection-problems-with-reporting-services.

    Best regards,
    Aniya

    0 comments No comments

  5. Fred Schmid 6 Reputation points
    2023-06-15T01:40:54.1133333+00:00

    I believe this was a similar problem I asked about in another question in this forum.

    I had to reformat my hard drive and reinstall Windows for a hardware problem. Now everything is working as it should. I believe there were corrupted file in my Window OS.

    Fred

    0 comments No comments