sql server reporting services: Hi,

Env: Win2003 SP1 + SQL 2005 + SQL 2005 reporting service (named
instance). I have local admin privilege.

I tried to follow the example described in
http://msdn2.microsoft.com/en-us/library/ms345334.aspx to set up web
service as data source in SQL reporting service 2005.
My data source URL is
http://localhost/reportserver$minuet/reportservice2005.asmx
My query is
<Query>
<SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportservices/ListChildren</SoapAction>
</Query>

But I keep getting the following errors:

===================================

An error occurred while executing the query.
Failed to execute web request for the specified URL. (Microsoft Report
Designer)

===================================

Failed to execute web request for the specified URL.
(Microsoft.ReportingServices.DataExtensions)

------------------------------
Program Location:

at
Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.ExecuteWebRequest(ICredentials
credentials)
at
Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.Execute()
at
Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.<>c__DisplayClass1.<ExecuteReader>b__0()
at
Microsoft.ReportingServices.DataExtensions.XmlDP.WebRequestHelper.ExecuteServerCallAsNtUser(ServerCall
serverCall, WindowsIdentity ntUser)
at
Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.ExecuteReader(CommandBehavior
behavior)
at
Microsoft.ReportingServices.QueryDesigners.QueryResultsGrid.ExecuteQuery()

===================================

<?xml version="1.0" encoding="utf-8"?><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><soap:Fault><faultcode>soap:Client</faultcode><faultstring>System.Web.Services.Protocols.SoapException:
Server did not recognize the value of HTTP Header SOAPAction:
http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportservices/ListChildren.
at
System.Web.Services.Protocols.Soap11ServerProtocolHelper.RouteRequest()
at
System.Web.Services.Protocols.SoapServerProtocol.RouteRequest(SoapServerMessage
message)
at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type
type, HttpContext context, HttpRequest request, HttpResponse response,
Boolean&amp; abortProcessing)</faultstring><detail
/></soap:Fault></soap:Body></soap:Envelope>


-------

The IIS log file has the following entries:
2006-02-09 01:48:45 127.0.0.1 POST
/reportserver$minuet/reportservice2005.asmx - 80 - 127.0.0.1 - 401 2
2148074254
2006-02-09 01:48:45 127.0.0.1 POST
/reportserver$minuet/reportservice2005.asmx - 80 - 127.0.0.1 - 401 1 0

--------
All of the above seemed to suggest there is a permission/credential
issue. But I was able to use IE to connect to
http://localhost/reportserver$minuet/reportservice2005.asmx without
problem.

Any ideas what went wrong? Any suggestions/pointers are appreciated.

Thanks.

Kong

I have a similar problem, and haven't been able to figure it out. I can
create and deploy the tutorial report with success, but when I use my
own webservice and wsdl with my own namespace, I can invoke the method
via ie, I can run the report in Preview and DebugLocal mode, but when I
put it up to the server, it gives me this:

An error has occurred during report processing.
Query execution failed for data set 'DataSet1'.
Failed to execute web request for the specified URL.
<?xml version="1.0" encoding="utf-8"?><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><soap:Fault><faultcode>soap:Client</faultcode><faultstring>System.Web.Services.Protocols.SoapException:
Server did not recognize the value of HTTP Header SOAPAction:
http://jplnet/webservices/GetReportLibrary. at
System.Web.Services.Protocols.Soap11ServerProtocolHelper.RouteRequest()
at
System.Web.Services.Protocols.SoapServerProtocol.RouteRequest(SoapServerMessage
message) at
System.Web.Services.Protocols.SoapServerProtocol.Initialize() at
System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type,
HttpContext context, HttpRequest request, HttpResponse response,
Boolean&amp; abortProcessing)</faultstring><detail
/></soap:Fault></soap:Body></soap:Envelope>

this is the query call:

<Query>
<Method Namespace="http://jplnet/webservices/"
Name="GetReportLibrary"/>
<SoapAction>http://jplnet/webservices/GetReportLibrary</SoapAction>
<ElementPath
IgnoreNamespaces="True">GetReportLibraryResponse/GetReportLibraryResult/diffgram/NewDataSet/Table</ElementPath>

</Query>

and here is the web method:

[WebMethod ]
public DataSet GetReportLibrary() {
SqlConnection l_cn;
SqlCommand l_cmd;
SqlDataAdapter l_da;
DataSet l_ds;

//get our report metadata
l_cn = new SqlConnection(ConfigEncryptionHandler.Settings["cn"]);

l_cmd = new SqlCommand();
l_cmd.CommandType = System.Data.CommandType.StoredProcedure;
l_cmd.Connection = l_cn;
l_cmd.CommandText = "rpt_JPLLibrary";

l_da = new SqlDataAdapter(l_cmd);
l_ds = new DataSet();

l_da.Fill(l_ds);

//close all collections
l_cn.Close();

return l_ds;
}


And even if I copy the project over to the actual server box, it will
run in Preview and Debug Local modes fine, but not when it is deployed
up to IIS

can anyone help?