Solved

timeout error when running reports that are not on the server

Posted on 2015-02-11
3
27 Views
Last Modified: 2015-07-10
I have SSRS reports that i deployed to the SSRS/SQL server.  I can view them in Report Manager and they come up VERY quickly.  However, when people try to connect to report manager from a different computer they get a timeout error.  Any reason why?
0
Comment
Question by:vbnetcoder
  • 2
3 Comments
 
LVL 28

Accepted Solution

by:
sammySeltzer earned 500 total points
Comment Utility
Hi,

First, ask your users to fix their browsers.

They do so by going to:

Internet Options
Click on the Advanced tab
Scroll down to Browsing section. While on this section, look for Show friendly HTTP error messages
. Uncheck the box.

Apply
Close browse and ask them to try again.

This should review the actual problem they are running into.

Based on what the actual reason is or reasons are, try the following:

a.       Open the ReportServer’s Web.config file by going to Start -> Administrative Tools -> Internet Information Services.
 b.      From there, expand Web Sites -> Default Web Site, and click on ReportServer. On the right-hand pane, right-click ‘Web.Config’ and select ‘Open’.
 c.       Locate the HttpRuntime parameter. If it doesn’t exist, you will have to create it within the <System.Web> section.
 d.      Set the executionTimeout value to ‘10800’ (3 hours) as shown below:


<system.web>
 <httpRuntime executionTimeout = "10800" />
 </system.web>


2) Increase the script timeout on the report server

    1. Go onto your Reporting Server and open up Internet Information Services; right-click on the ReportServer and select Properties.
    2. Go to the Options tab, and set the ASP Script timeout to 300 seconds as shown below.

3) Set the report to never time out on the server

    1. Open your web browser on the server and go to http://localhost/Reports
    2. Navigate to the Report location and click on the problem report(s).
    3. On the left-hand pane, click on Properties.
    4. In the ‘Report Execution Timeout’ click the ‘Do not timeout report execution’.

For more, check out this link:

http://geekswithblogs.net/ssrs/archive/2009/10/30/steps-to-resolve-ssrs-timeout-issues.aspx
0
 

Author Comment

by:vbnetcoder
Comment Utility
will get back to this
0
 

Author Closing Comment

by:vbnetcoder
Comment Utility
ty
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now