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.