July 14, 2008 at 10:59 am
How can I adjust my Reporting Services installation to bypass prompting for each user's Windows Login?
Each morning, our BIO access our RS link and he gets prompted for his Windows Login & pwd. He asked if there's any way to enable Windows security on this IIS instance so it doesn’t prompt for password?
July 15, 2008 at 4:38 am
couple of things spring to mind
1 make sure that his internet browser recognises the reportserver site as a trusted site
2 windows integrated security on the datasource connection
3 that he is in a recognised security group on the reportserver
July 15, 2008 at 4:52 am
I guess you mean to avoid the popup and take the login as whoever has logged into the machine. If so, work on the security settings of the browser you are using.
July 15, 2008 at 1:11 pm
From the SSRS home screen, I've created an RS role 'EVERYONE' which allows Browser access (May view folders, reports and subscribe to reports.)
Does SSRS 2005 mandate that everyone accessing a publicly viewable report sign-in w/ their Windows ID at least once (1st time in during the day)?
If so, we'd like to understand if there's a mechanism to bypass the Windows pop-up login screen.
July 16, 2008 at 2:58 am
Does IIS allow anonymous access to the site or does it require authentication? If you switch to anonymous, everybody should be able to get to the report but at the cost of disabling part of your security model
July 16, 2008 at 6:05 pm
Does the connection string on your data source in the report point to a different server than the one hosting your RS reports? If so to use Windows auth you'll need to be able to pass through the users' credentials to the DB server. This requires correctly setup Kerberos delegation in your AD domain - see this thread for pointers: http://www.sqlservercentral.com/Forums/Topic306519-147-1.aspx
Regards,
Jacob
July 16, 2008 at 7:45 pm
If he's getting prompted but it's then going through, it's likely not a Kerberos delegation issue. It's likely an authentication issue on IIS. These will help:
Kerberos authentication and troubleshooting delegation issues
The problem could be at either IIS or Internet Explorer or both and this KB article covers both.
K. Brian Kelley
@kbriankelley
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply