Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kokank
Starting Member
1 Post |
 Posted - 2005-01-08 : 11:03:03
|
| I have a report that takes very long time to execute. While execution, I am prompted to enter my Windows username and password and if I don't the report execution cancells. Is this because of the Authentication in IIS set to Basic only. Is there anything workaround in MSRS. |
|
|
jhermiz
3564 Posts |
Posted - 2005-01-08 : 12:30:51
|
Check the credentials on the data source of the report. If you double click on the datasource you should be able to tab into the credentials section. Make sure you have a valid login and password in the datasource that has the rights to access the data.Also one other thing...in http://yourreportserver/reportsthere is a security section. Add the group(s) or users you want to be able to view the reports. This will use their NT security and will not prompt them for a user name and password.If the report is taking too long as well, it means you are pulling a lot of records from the db. Try to make the report a parameterized report helping you tighten up that sql and return only a limited number of records, i.e WHERE.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
|
 |
|
|
|
|
|
Report Execution