topic Re: OData exception occurred: System.Net.WebException:The request failed with HTTP status 401.Unauth in Report Server

OData exception occurred: System.Net.WebException:The request failed with HTTP status 401.Unauthoriz

CamilleS — Thu, 25 Jan 2024 11:38:29 GMT

Hello Microsoft Support & community,

After the installation of power bi report server (may 2023 version) the users are getting the error message "An error has occured. Try again later" on scheduling creation or modification on Power BI Report Server portal.

(users have content manager profile on the directory where the reports are saved; they have also “system user” on security site parameters level)

The error in the log RSPortal_2024_01_25… ==>

2024-01-25 11:10:45.7026|ERROR|19|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)

at Microsoft.ReportServices.Portal.Services.SoapProxy.SoapRS2010Proxy.<>c__DisplayClass1_0.<ExecuteWithCorrespondingAuthMechanism>b__0().....

When adding a user to the local admin group on the server (BUILTIN\Administrators) creating or modifiying scheduling works as expected. But the point is, we don't want to make every report developer/author server admin.)

Thank you for your help.

Re: OData exception occurred: System.Net.WebException:The request failed with HTTP status 401.Unauth

Anonymous — Fri, 26 Jan 2024 02:11:12 GMT

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)

The strange case of Data source can’t be created with Reporting Services 2016 in Azure VM | Microsoft Learn

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.

Re: OData exception occurred: System.Net.WebException:The request failed with HTTP status 401.Unauth

CamilleS — Tue, 06 Feb 2024 15:30:18 GMT

Hi Community Support Team _ Rongtie,

Thank you for your answers....

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 idea how to resolve this issue ?

Thank you for your help.

BR, Camille.

Re: OData exception occurred: System.Net.WebException:The request failed with HTTP status 401.Unauth

CamilleS — Wed, 07 Feb 2024 16:25:13 GMT

Hi Community Support Team _ Rongtie,

Thank you for your answers....

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 idea how to resolve this issue ?

Thank you for your help.

BR, Camille.

Re: OData exception occurred: System.Net.WebException:The request failed with HTTP status 401.Unauth

CamilleS — Fri, 09 Feb 2024 12:09:40 GMT

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.