Forum Discussion
401.2 Access denied when testing the ReportServer URL as a regular windows user
I know this is an old issue at this point, but I found a solution for this symptom -- it turns out there is a 'web.config' file in the ...ReportServer directory. This file has an 'httpModules' section that has a line with '<add name="UrlAuthorization"...' in it. I removed that line, saved the web.config, and restarted the SSRS service. This caused the symptom to disappear. I believe we had IIS installed on this server at one point in time, and somehow the server default URL Authorization rule prohibiting all but 'Administrators' must have been getting interpreted by SSRS... (We have another server where this line in the 'web.config' does not cause the described problem symptom.)
I have been trying to solve this issue for a long time. Any attempt to change configuration did not work, until this one.
I am not sure whether there is any relationship. We migrated a SSRS database from a SSRS 2014 to a SSRS 2019. I could not edit any report or data sources. This configuration change (removing UrlAuthorisation configuration line from web.config) solved the problem.
Thank you.