Site icon Paul Turley's SQL Server BI Blog

User is prompted to login when viewing a report

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.

Exit mobile version