Post reply

While Running SQL 2000 Reporting Services Report gets login Prompt

  • June 2, 2008 at 8:24 pm

    #207991

    We are running SQL 2000 Reporting Services on an internal site. The security settings are set to let everyone run reports in a certain folder. Recently when running some of these reports, users are getting a windows login prompt half way through the report run. Sometimes when they put in their domain/userid and password it finishes, although it usually ends up asking them 2 or 3 times. Sometimes rather than finishing after putting in the credentials, it ends up giving an access denied error and it does not finish.

    This appears to have started randomly and it does not happen everytime someone runs a report, but some longer running reports are having problems finishing successfully. Has anyone ever seen this type of behavior? What causes this?

    Thanks

    TJP8

  • June 3, 2008 at 8:10 am

    #823629

    Unfortunately that's fairly typical SSRS behavior for longish running reports. What's happening is you're hitting some kind of timeout. When that happens the user's stored credentials go out of focus.

    Extending your timeout limits may resolve this. If not, some other things to try are to optimize your SQL code as much as possible, cut down on bells and whistles (e.g. interactive sorting, multiple grouping, etc.) in the report itself and consider running the reports from snapshot data or as a subscription.

    HTH

    [font="Comic Sans MS"]toolman[/font]
    [font="Arial Narrow"]Numbers 6:24-26[/font]

  • June 3, 2008 at 11:37 am

    #823777

    Thanks for that information, I just find it sort of odd, that the reports don't seem to be taking any longer to run than they were, but all of the sudden this has started happening. The Timeouts that you are thinking about, is this probably a SSRS timeout or a database timeout setting? And where would that be located?

    Thanks,

    TJP8

  • June 3, 2008 at 11:48 am

    #823783

    Here are two of the timeouts I found. The SSRS site settings Report Execution Timeout was set to 1800 seconds (30 Minutes). I set it to Do not timeout, but I continue to get the same issue. The SQL Server instance Query Timeout found on the connections tab of the properties window is set to 600 seconds (10 Minutes).

  • June 3, 2008 at 2:36 pm

    #823873

    Another Update, I found the Report Execution Timeout on each report. I tried setting a report to 'Do not timeout report execution' There was no change. I also tried playing with the credentials section of the Data Sources and I did not get a change.

    All ideas or suggestions are appreciated

    Thanks,

    TJP8

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply