ssrs 2008 R2 web service connection/response is intermittent
hi I am posting this question since I have been struggling with it for weeks and still didn't find the solution. thanks in advance for any ideas/suggestions. I have a web application (written with VS 2008 SP 1, .net framework 3.5) which is hosted on a windows server 2008 R2. the web app calls SSRS which is hosted on a sql 2008 R2 database. the reference url (the execution endpoint) in the web.config of the ssrs is: http://servername/Reportserver_name/reportexecution2005.asmx db version: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) the problem is the downloading of 80 reports from the web is always stopped/failed in the middle. only a portion of the reports are downloaded. while a single report download never fails. Here is the exception: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.115.204.112:80 at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception) please note that it is not a soap exception. any help is appreciated. thanks
October 31st, 2012 10:52am

Hello, Can you open & view those report in the SSRS Report Manager URL without any failures like timeout?Olaf Helper Blog Xing
Free Windows Admin Tool Kit Click here and download it now
October 31st, 2012 1:59pm

thanks. yes, I can view the report without any problem in ssrs report manager web site. Only one report (within which there are 2 sub-reports) is invoked and rendered. the batch download is invoking that report with 80 different parameters, so reporting server will have to respond the request 80 times. and the failure happened somewhere in between these 80 tries. and the failure pattern seems random, sometimes it failed after 6 reports are downloaded and sometimes it stopped after 14 reports are done.jeff
October 31st, 2012 2:08pm

Hi Jeff, Based on the error message, the web application is unable to open a socket over port 80. The issue can be caused by various reasons. One possible reason is that the Firewall blocks the requests from the Web Application. Here, I suggest that you add new Firewall Inbound Rules for specific TCP/IP ports (that report server and web application use) referring to the following article: Configure a Firewall for Report Server Access Additionally, the issue may also occur due to the conflicts on port 80. So, you can try to use a different port for the Report Server Web Serivce URL reservation. Hope this helps. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here. Your Name TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
November 1st, 2012 10:48pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics