We have Reporting Services 2000 standard edition installed and everything works fine. You can log in and run reports and the Reporting Services security rolls work. The problem is when a user goes to the url of reporting services web server it prompts them for a login. They enter their Windows domain login and they get in. Is there a way to configure Reporting Services to use the user's Windows Domain login credentials (pass through) and not prompt for them, similar toSharePoint.Here is our configuration:
We have a NT Domain (not active directory) all servers and client machine’s are in the same domain.
IIS for Reporting Services is set to authenticate users by Integrated Windows authentication, Enable anonymous is unchecked.
Server is running Windows Server 2003 Web Edition
Database security utilizes sql server login and is storedin the data source.
We are also planning to move the access to Reporting Services through SharePoint.Don’t know if that will complicate this login issue
Thanks
Enable anonymous access should be checked. Username and password credentials should be given, uncheck Integrated Windows authentication|||I have a DotNetNuke portal running Reports from Reporting Services. I am having a problem because each time I access my ReportServer on a browser I am asked to authenticate myself. I am currently hosting my database on a hosting services company and I only have access to the Report Manager. Where should I define the access properties in the report manager for my report server?
The user I must use to authenticate is the main user which has full access to reports so this is not a viable solution.
Thanks for your help.
No comments:
Post a Comment