Web Services with Websphere

[Rommel Dela Cruz]

Anyone who has made a successfuly call to MS Reporting services using SOAP ?

I did put a trace using SQL Profiler showing that call was made. There was no error message returned so the call was successful. The problem is I am not getting the result back. But I am getting the result using the Web Services Test Explorer. Any setup that I missed ? By the way, I am using IBM Soap on WSAD. Thanks.

[Balaji Loganathan]

MS Reporting services: Is it something that is shipped with SQL server 2005 ?

Did you tried to use some tcp/ip sniffers to see what the soap request/response saying ??

TCP/IP trace http://www.pocketsoap.com/tcptrace/

[Rommel Dela Cruz]

It is bundled with SQL Server 2000 and 2005.

My websphere application (localhost running on 9080)is the client and RS is the server (a remote server running on port 80). I tried using the tcptrace.exe but I did not any trace. Not sure if I am doing it correctly. The name of the RS server is RSServer and the endpoint URL is http://RSServer/ReportServer/ReportExecution2005.asmx. I tried this for both using the URL and just plain RSServer as the destination server but no success. I did use port 8080 for "Listen on Port #" and of course port 80 on "Destination Port #". Am I doing something wrong why I am not getting the trace ?