Hello, when running my report with a Web Service as XML DataSource I get the following error message: "An error has occurred during report processing. Query execution failed for dataset 'SockQuote'. Failed to prepare web request for the specified URL." The error only occurs when I deploy the report to the report server and run it in IE. When I run the report directly in Visual Studio 2008 it works! Why? Thanks

How are you authenticating against the Web service?Cephas Lin This posting is provided "AS IS" with no warranties.

Hi ax123, The error message that you provided is quite general, various possible cause could make it from occurring. For example, the data source does not available, or the Query Methord defined in DataSet does not work. Currently, I would suggest you check the following article for more information about XML Query first, Creating Report Datasets from XML Data: http://msdn.microsoft.com/en-us/library/ms159741(v=SQL.100).aspx XML Query Syntax for Specifying XML Report Data: http://msdn.microsoft.com/en-us/library/ms345251(v=SQL.100).aspx Element Path Syntax for Specifying XML Report Data: http://msdn.microsoft.com/en-us/library/ms365158(v=SQL.100).aspx Then, please verify the DataSource string, and the DataSet queries. Make sure that they are validated. Third, please re-deploy the report again, and see if error reoccurs or not. If the problem persists, please kindly provide the DataSource string, the DataSet query, and the detailed error message. Thanks, Eileen.

I use authentication "no credentials".

Hi ax123, If you select no credentials, Anonymous access is used. Make sure that you have defined the unattended execution account for the report server to connect to an external data source. The XML data processing extension does not pass credentials to the target URL or the Web service; the connection will be unsuccessful unless you have defined the unattended execution account. For more information, see Configuring the Unattended Execution Account. For more information about the topic, please see the articles I have mentioned above. Thanks, Eileen