On our SQL2005 PROD installation, we just uploaded a new report that uses the same shared data source that our other reports use successfully.
The report calls a query that takes about 3 minutes to run under the same User/Pass that the shared data source uses. When run on our PROD reporting services instance, it stays at "Report is being generated" for roughly 5 minutes and then displays
a browser prompt for credentials. If you enter valid credentials, the process repeats -- roughly 5 minutes of "Report is being generated" then another prompt for credentials.
I've done the basic stuff of triple checking the shared data source, etc. and can't seem to find any difference between this report and the one that are working fine. What can I do to fix this?The Pragmatic TSQL Programmer
View Complete Post