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

  • 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

    Tuesday, June 23, 2020 7:52 AM

All replies

  • 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 MSDNFSF@microsoft.com.

    Wednesday, June 24, 2020 2:46 AM
  • 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 MSDNFSF@microsoft.com.

    Monday, June 29, 2020 1:11 AM
  • 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?
    Thursday, July 2, 2020 8:18 AM
  • 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






    Wednesday, July 8, 2020 10:22 AM