Why does my Reporting Services Web Service URL not work?

asked 2022-12-23T15:21:11.307+00:00
Fred Schmid 1 Reputation point

I have installed SQL Server 2019 Developer edition on my Windows 11 PC. And I installed Reporting Services also. I got the report server to say it is "Report Service Status: Started". When I try to access the Web Service URL I get 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.

Any ideas why the URL is not working?

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

1 answer

Sort by: Most helpful
  1. answered 2022-12-26T03:06:00.337+00:00
    AniyaTang 2,026 Reputation points Microsoft Employee

    Hi @Fred Schmid
    I created the same environment as you, and when I access the Web Service URL and Web Portal URL, I don't get the error you mentioned.

    Based on my search, if there is an authentication setting conflict between the report server Web.config file and the RSReportServer.config file, HTTP 401 and HTTP 500 errors are generated. For more details, you can refer to this link: https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms159778(v=sql.105).

    If the link I provided for you doesn't work, perhaps you can use the phone service to check your server status more closely and usually solve your problem.
    https://support.microsoft.com/en-us/help/4051701/global-customer-service-phone-numbers
    https://support.microsoft.com/en-us/supportforbusiness/productselection

    Best regards,
    Aniya

    No comments