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