Is there any way to run a report via a URL without having the user login?
Could I provide special parameters on the url or define a user/password in the report itself?
We do NOT use active directory.
Thanks.
You can store the credentials needed for the data source access on the report server.
Check this BOL link: http://msdn2.microsoft.com/en-us/library/ms160330(SQL.90).aspx
Also check the links at the bottom of that page which describe how to manage data source credential settings via Report Manager and Management Studio.
-- Robert
I have the data source setup ok - that's not what is generating the login request. It's report server itself and it's not obvious how I can get around that.
Most likely, in IIS the virtual roots for /reportserver or /reports have a directory security configuration -> authentication methods different from "Integrated Windows Authentication" only. So it is really IIS asking to login - not Reporting Services.
-- Robert
