Report Server Error: "The request failed with HTTP status 401: Unauthorized

Question

Hello,

I am getting this error when I am running SQL Server Report.

The service account is Admin and able to open manually from the browser but when I am running from ESP or command prompt I am getting error "HTTP status 401: Unauthorized".

Other user is able to execute this report, I am not able to understand what is the issue with the service account.

Window Server version :2003

Could you please give suggestion, what I can do here.

Thanks

Sandeep

Answer 1

Hi Sandeep Devadiga,

Could you please check the log file which is located C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles (SSRS 2017 and later) or C:\Program Files\Microsoft SQL Server\MSRS1x.MSSQLSERVER\Reporting Services\LogFiles (SSRS 2016 and earlier) to seeif the SSRS log can trace some information that is useful for diagnose?

In addition, if using Kerberos authentication, please make sure SPN is configured correctly.

Please refer to the following articles which might help:

Register a Service Principal Name (SPN) for a Report Server

Configure Windows Authentication on the Report Server

Best Regards,

Amelia

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

Hi Sandeep Devadiga,

Was your issue resolved?

If the replies could help you, please mark the useful reply as answer to help other community members find the helpful reply quickly.

If not, please don't hesitate to let us know and share us the error message in order to provide further help.

Best Regards,

Amelia

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 3

Hi Amelia,

I don't have permission for registering SPN, I am checking with Admin team and I can post it here about it.

Below are the few part of RSReportServer.config

<URLReservations>
  <Application>
   <Name>ReportServerWebService</Name>
   <VirtualDirectory>ReportServer</VirtualDirectory>
   <URLs>
    <URL>
     <UrlString>http://host:80/Reportserver</UrlString>
     <AccountSid>S-1-5-20</AccountSid>
     <AccountName>NT Authority\NetworkService</AccountName>
    </URL>
    <URL>
     <UrlString>http://host:80</UrlString>
     <AccountSid>S-1-5-20</AccountSid>
     <AccountName>NT Authority\NetworkService</AccountName>
    </URL>
   </URLs>
  </Application>
  <Application>
   <Name>ReportManager</Name>
   <VirtualDirectory>Reports</VirtualDirectory>
   <URLs>
    <URL>
     <UrlString>http://host:80</UrlString>
     <AccountSid>S-1-5-20</AccountSid>
     <AccountName>NT Authority\NetworkService</AccountName>
    </URL>
   </URLs>
  </Application>
 </URLReservations>
 <Authentication>
  <AuthenticationTypes>
   <RSWindowsNegotiate/>
   <RSWindowsNTLM/>
  </AuthenticationTypes>
  <EnableAuthPersistence>true</EnableAuthPersistence>
 </Authentication>

The job is running with service account.

And I an getting popup error "wmi encountered a problem and needed to close" 

can we edit(or remove RSWindowsNegotiate) from RSReportServer.config?

Answer 4

Hello,

I see below error in Log Path: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles

e ERROR: Configuration file element URLs has an invalid URL 'http://host:80/Reportserver'. It will be ignored.

Manually I can open the report.

Config.xml content

<SSRSUrl>
  <ReportServiceUrl>http://host:80/reportserver/reportservice2005.asmx?</ReportServiceUrl>
  <ReportExecution />
  <ReportServer>host</ReportServer>
  <ReportServerpath>/projectPath/</ReportServerpath>
  <Dqa>xyz</Dqa>
  <DqaPhone>1234</DqaPhone>
  </SSRSUrl>

How can I identify if it is using Kerberos authentication ?

Thanks,

Sandeep

Answer 5

I have fond out what's causing Error: "The request failed with HTTP status 401: Unauthorized".

In Reporting service configuration manager I need to provide user account details in service account tab but its asking for backup while I provide user account details which I don't have. So going for workaround.

Thank you for your support.

Regards,

Sandeep