Hello Everyone,
I was trying to Create a subscription to run a SQL Server report by calling the Reporting Web service using a JAVA/SOAP client. The input SOAP message is as follows. I am trying to run from an AIX box (the web service is running in a Win 2003 server..) When I try to run I get this error.. Can someone please help...
SEVERE: SAAJ0008: Bad Response; Unauthorized
Exception from Outer Loop:com.sun.xml.messaging.saaj.SOAPExceptionImpl: java.security.PrivilegedActionException: com.su
n.xml.messaging.saaj.SOAPExceptionImpl: Bad response: (401Unauthorized
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Header/><SOAP-ENV:Body><CreateSubscription xmlns="http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices"><Report>/FROI/Report1</Report><Parameters><ParameterValue><Name>trid</Name><Value>EB000047</Value></ParameterValue></Parameters><ExtensionSettings><Extension>Report Server Email</Extension><ParameterValues><ParameterValue><Name>TO</Name><Value>jmundanat@cvty.com</Value></ParameterValue><ParameterValue><Name>Subject</Name><Value>@ReportName was executed at @ExecutionTime</Value></ParameterValue><ParameterValue><Name>RenderFormat</Name><Value>PDF</Value></ParameterValue><ParameterValue><Name>IncludeReport</Name><Value>True</Value></ParameterValue><ParameterValue><Name>Comment</Name><Value></Value></ParameterValue></ParameterValues></ExtensionSettings><EventType>TimedSubscription</EventType><MatchData><ScheduleDefinition><StartDateTime>2010-02-12 11:19:18</StartDateTime></ScheduleDefinition></MatchData></CreateSubscription></SOAP-ENV:Body></SOAP-ENV:Envelope>