Forum Discussion
OData exception occurred: System.Net.WebException:The request failed with HTTP status 401.Unauthoriz
- Anonymous2 years ago
Hi CamilleS ,
When attempting to configure and connect to Report Server, the following error appears: Report Server Error: The request failed with HTTP status 401: Unauthorized.
There may be two causes for this error.- The Password Manager Account may not have the correct permissions to access the Reporting Services Server (i.e. Content Creator rights on the SRS Reporting side).
- In complex network environments Windows Integrated Security may fail to authorize the user (client) on the Reporting Services Server because the authorization request is transferred through Password Manager server with impersonated credentials. This case is known as a double-hop issue. A double-hop issue occurs when the SQL Database and the SQL Reporting Services are on two different servers.
More details: Report Server Error: "The request failed with HTTP status 401: Unauthorized" (4227098) (oneidentity.com)
I have also found a helpful post, please refer to it to see if it helps you.
reporting services - HTTP Error 401 when trying to view SSRS 2019 subscription - Stack Overflow
If it does not help, please provide more details with the error.
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi CamilleS ,
When attempting to configure and connect to Report Server, the following error appears: Report Server Error: The request failed with HTTP status 401: Unauthorized.
There may be two causes for this error.
- The Password Manager Account may not have the correct permissions to access the Reporting Services Server (i.e. Content Creator rights on the SRS Reporting side).
- In complex network environments Windows Integrated Security may fail to authorize the user (client) on the Reporting Services Server because the authorization request is transferred through Password Manager server with impersonated credentials. This case is known as a double-hop issue. A double-hop issue occurs when the SQL Database and the SQL Reporting Services are on two different servers.
More details: Report Server Error: "The request failed with HTTP status 401: Unauthorized" (4227098) (oneidentity.com)
I have also found a helpful post, please refer to it to see if it helps you.
reporting services - HTTP Error 401 when trying to view SSRS 2019 subscription - Stack Overflow
If it does not help, please provide more details with the error.
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Community Support Team _ Rongtie,
Thank you for your answers....but my issue is not resolved 😞
Users who are part of Administrators group on the Server Machine don't have the error
while those who have not are still having the error.
In other words a user need absolutly to be part of Administrators Group on the server machine to stop having thios error :
OData exception occurred: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetConnectionProtocol()
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetCacheRefreshPlanProperties(String cachRefreshPlanId, String description[] parameters)
it is out of question to give admin rights to all users to enable them to create /modifiy Schedules.....
Any new idea how to resolve this issue ? please don't copy/paste the same answer..
Thank you for your help.
BR, Camille.