Reporting Services - Login box appears in the middle of running a report

  • On Reporting Services 2005 we are experiencing an issue while running reports. The user is authenticated on the report server using Kerberos and the Reports run using a hard coded ID to connect to SQL Server.

    We are able to start running the reports successfully and quick returning reports always run. However sometimes in the middle of a running a report, a popup login box will appear. If we type in our username and password the report will continue to run. Sometimes the window will popup again before the report completes. If I do not type my username and password or type it incorrectly the report will stop processing.

    This doesn't happen in a predictable fashion, but happens more often on longer running reports. I have never seen it happen on a report that takes less than 5 mins to run. But the longer it takes, the more likely it appears to happen.

    Has anyone else seen this issue? If so, have you found a fix or a server setting change to correct this?

    Thanks.

  • On Reporting Services 2005 we are experiencing an issue while running reports. The user is authenticated on the report server using Kerberos and the Reports run using a hard coded ID to connect to SQL Server.

    In SQL Server 2005 SSRS is Asp.net dependent so the question is what type of permission is the Asp.net account running on? You know AD permissions are not relevant to Asp.net because Asp.net permissions are resolved in IIS.

    Kind regards,
    Gift Peddie

  • I'm not positive what security/accounts asp .net or IIS are running under on our server, as I don't have any permission to see that at my company. I am at a disadvatage here as the Security and Server folks are often to busy to troubleshoot an issue like this, and often reply with a "that's just the way it is" type of response.

    Although I might be wrong, to me, it doesn't appear to be a security or permission issue as the reports will execute absolutely fine, with no popup login box if it is a short running report. If the popup box does appear it will not appear until atleast 5 mins after the report has started running.

  • dspohn23 (1/6/2010)


    I'm not positive what security/accounts asp .net or IIS are running under on our server, as I don't have any permission to see that at my company. I am at a disadvatage here as the Security and Server folks are often to busy to troubleshoot an issue like this, and often reply with a "that's just the way it is" type of response.

    Although I might be wrong, to me, it doesn't appear to be a security or permission issue as the reports will execute absolutely fine, with no popup login box if it is a short running report. If the popup box does appear it will not appear until atleast 5 mins after the report has started running.

    It is permission but yes you need to know the details to tell them what is wrong, if IIS and SQL Server are in separate boxes that is double hop so Asp.net needs permissions in both boxes.

    Kind regards,
    Gift Peddie

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

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