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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,894 questions
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.
2,824 questions
{count} vote

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 33,551 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.