SSRS 2019 Https Web Portal URL asking username and password on all activities like open/drilldown(On Click)

nanda kishore 6 Reputation points
2021-02-04T22:29:15.55+00:00

Installed SQL Server 2019, SSRS 15.0 Version. Deployed Reports to https URL with certificate. I could deploy and access reports in local (Requested credentials at login - only once). But when I'm accessing the reports outside VM to Https URL, It is asking for credentials on login, After accessing any report, sometimes in middle of something.
Tried it in various browsers, same issue for all.
Even If I enter credentials, it will ask for 4 to 5 times continuously. After that it will not ask until I access another folder.

64222-image.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
SQL Server | Other
{count} vote

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 41,536 Reputation points
    2021-02-05T06:08:47.313+00:00

    Hi @nanda kishore ,

    Please try this:

    1. Open Internet Explorer
    2. Go to Tools and click on Internet Options
    3. Under the Security tab, click on Trusted sites and click the Sites button and Add Report Manager/Report Server URL to the trusted sites.
    4. Then click Custom Level, and check the option Automatic logon with current user name and password
    5. Access the url for a try

    64432-screenshot-2021-02-05-140213.jpg

    If this doesn't help, please help check if you are using Kerberos authentication.

    To deal with this issue, please try to remove RSWindowsNegotiate and ensure RSWindowsNTLM is specified in the rsreportserver.config file.

    Or you may follow this to implement Kerberos Delegation with SSRS.

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.