How to disable login prompt while accessing SSRS Report?

  • Hi,

    I have installed SQL Server 2008 R2 Reporting Services on one of my servers. Everytime i am trying to access the reports, IE is prompting for user name and password. Could someone let me know how to avoid this prompt? I am using BasicAuthentication.

    <AuthenticationTypes>

    <RSWindowsBasic />

    </AuthenticationTypes>

  • If it ios not an extranet server, I would use Windows authentication.

  • Hi,

    When i used Win Authetication i am still being asked for the uid and pw. The prompt will be displayed continuosly and after 3 attempts it will display blank screen.

    <AuthenticationTypes>

    <RSWindowsNTLM />

    </AuthenticationTypes>

  • Is your Report Server configured for your Windows login?

    You may wish to check http://msdn.microsoft.com/en-us/library/ms156034.aspx.

    One small trick: Under Start (or Windows or whatever it is in Win7) > Accessories > System Tools right-click on Internet Explorer (no Add-ons) and select Run as administrator.

    Hit http://yourServer:8080/reports

    Then follow the instructions in the linked MSDN article.

    Good luck.

    I will be back online ~8 PM Pacific Time.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply