We have developed a portal using ASP.Net and C# and generating reports using SSRS. When the user logs into the site, system will open a page with 4 reports (dashboard page). It is working fine in development environment. But when we deploy the application on Production environment (with DB clusters and Load balancing app server on cloud env) the reports are not shown. Getting the following error some times (not always) - Unable to connect to the remote server. 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.106.52.4:80. Can you please help us about this issue. Note – we are getting this error when the application server and db servers are on separate server boxes. When we try this keeping app server and db server on same server box, it is working fine. We have also tried following options on production env – (1) Configured SQL Server Database engine for the better performance, (i) Set Fixed memory (75% of available RAM in the server) (ii) Cost Threshold for Parallelism- 6 from 5 (iii)Degree of Parallelism=N/2-1 where N is the number of core. (2) OS Level (Both Application Server and Cluster Node) (i) Set Virtual memory custom size. Initial Size=size of RAM Max size=1.5* size of RAM (ii) Set LockPage in memory (3) Report Server (i) Assigned user account as Network service and Domain User (admin of Cluster Service) and tested. Now it set with Domain User as user account. (ii) given full control to file C:\winNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files for Network Service account. (4) Changed security settings on application server from default settings to NTLM settings.

Hi svipp, Based on the error message, the problem we are experiencing could be related to the network connectivity between the SSRS and the SQL server cluster. I am not sure which cluster/load balancing technology that you are using, but I think the issue is properly be related to follows, 1. SSRS server sent out the request, but the SQL server cluster/load balancing device cannot received the request, In this case, I'd suggest you check the network device between the SSRS and the device. 2. SQL Server cluster/load balancing device received the request from SSRS, but it did not forward to backend SQL server If that is the case, involve the device vendor to check. 3. SQL server received the request, and responded, but the SSRS server did not receive any response from SQL server. In this case, we still need to check the intermediate network device between them as the request could be dropped by them. At last, I think you may connect the SSRS server to a dedicate SQL server for further isolate. If the connection can be made, I think we need to involve proper resource to check the cluster/load balancing. If you are running Microsoft Cluster service, you can ask question here: http://social.technet.microsoft.com/Forums/en/winserverClustering/threads Thanks, Eileen.