0 Replies Latest reply on May 27, 2013 7:33 AM by Ashish Todon

    Getting "401 Unauthorized"  status code while calling SSRS 2008

    Ashish Todon Level 1

      Hi,

       

      I am getting this response while calling report server service hosted in other machine where as i got success response if i call SSRS sever hosted in my local:

      seZKBKde-6cSpL8E7u0b2kg (1).png

       

      This is the code i am using:

       

      <cfset str = "/test/Report1"/>

      <cfsavecontent variable="soapvar" >

          <cfoutput>

              <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"

             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

             xmlns:xsd="http://www.w3.org/2001/XMLSchema">

              <soap:Body>

                  <DeleteItem xmlns="http://www.microsoft.com/sql/ReportingServer">

                      <item>#str#</item>

                  </DeleteItem>

              </soap:Body>

          </soap:Envelope>

          </cfoutput>

      </cfsavecontent>

        

      <cfhttp

          url="http://192.168.10.251/reportserver/reportexecution2005.asmx"

          method="post"

          result="httpResponse"

          username="Domain_name\username"

          password="password"

          getasbinary="yes">

         

          <cfhttpparam

              type="xml"

              value="#trim( soapvar )#"/>

       

      </cfhttp>   

       

      <cfdump var="#httpResponse#">

       

      Same code is working fine whem i call SSRS server in my local