January 6, 2010 at 9:38 am
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.
January 6, 2010 at 10:47 am
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
January 6, 2010 at 1:32 pm
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.
January 6, 2010 at 3:17 pm
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