http://www.sqlservercentral.com/blogs/pturley/2010/03/16/user-is-prompted-to-login-when-viewing-a-report/

Printed 2014/08/22 06:22AM

User is prompted to login when viewing a report

By pturley, 2010/03/16

A user has been added to a SSRS role for the report folder or report but is still prompted to login. This can happen if Internet Explorer isn't configured to persist the user's Windows login to Intranet sites.

To rectify this, in Internet Explorer open Tools > Internet Options > Security tab

Change the settings for the Local Intranet Zone by clicking Custom Level

Near the bottom of the list of settings under User Authentication, select the radio button for the option titled:
Automatic logon with current user name and password

Click OK to close and save the settings and then restart IE.



Weblog by Paul Turley and SQL Server BI Blog.
Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.