Useful post on debugging a 'Failed to execute web request for the specified URL' error returned from SSRS when consuming the SharePoint 'GetListItems' webservice as a data source
http://nishantrana.wordpress.com/2008/11/05/failed-to-execute-web-request-for-the-specified-url-sharepoint/