SSRS Prompting for Credentials

  • I have setup SSRS 2019 and I have done everything I thought needed to be done to allow seamless connections with Windows accounts but when I access the Report Manager with the "http://hostname/reports" (or http://hostname:80/reports") a window pops up asking me for my credentials.  When I use "http://localhost/reports" it works just fine.

    Here is what I have done:

    1. Running the service as a domain account
    2. Setup SPN's for the service account for both SQL Server and Reporting Services.
    3. I have updated the RSReportServer.config file to have the following three settings:

      <RSWindowsNegotiate />

      <RSWindowsKerberos />

      <RSWindowsNTLM />

    I have restarted the service and I am getting the same issue.

    Can anyone tell me what I am missing?

    ----------------------------------------------------------

    01010011010100010100110000100000010100110110010101110010011101100110010101110010
    001000000101001001101111011000110110101101110011

  • Does the account also have delegation rights?

  • First, yes, the account has delegation rights.

    Second, I wanted to provide an update that I finally found the solution this morning.  The issue was the browser.  This particular server only has IE so that is what I was using.  In the "Internet Options", go to the Security tab and go to Trusted Sites.  (I had previously added this site to the Trusted Sites.)  Within Trusted Sites, choose the Custom Level button.  Go to the very last option, User Authentication, and select the option "Automatic logon with current user name and password".

    ----------------------------------------------------------

    01010011010100010100110000100000010100110110010101110010011101100110010101110010
    001000000101001001101111011000110110101101110011

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

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