Home Forums Reporting Services SSRS 2012 Prompt for Windows Authentication when accessing report folders/reports RE: Prompt for Windows Authentication when accessing report folders/reports

  • October 11, 2017 at 8:56 am

    #1963197

    jcourtjr 29296 - Wednesday, October 11, 2017 8:36 AM

    So there is a lot of talk of turning off the prompt for accessing reports, I want to turn it on.

    Right now we have a report that users can access via Windows Authentication (the data source of the report is stored so is not relevant here). What we would like to do is have the user be able to change the windows account they are using when accessing the report. For example, user does not have access to the report or folder in ssrs. When they go to the url, we would like to have a prompt to let them enter those AD credentials (which will be different from the one they logged into their workstation with).

    If you are using IE, then you can't have a different user log in as the credentials are automatically passed over using integrated security. If, however, you are using a different browser (for example Firefox, Chrome), then a dialogue box will be presented, as they do not support integrated security.

    If, however, IE is the only option, you'll need to run IE as a different user. To do so hold shift and right click the IE icon, then select Run as different user (as shown below). You'll then be presented with a Windows login dialogue, where you can enter a different user's credentials

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk