How to Fix SSRS prompting for user name/password?

Amit M 0 Reputation points
2023-02-06T11:25:16.1233333+00:00

I am accessing SSRS reports using URL method in my UI by using iframe element in React js . Whenever I open it for first time it will ask me for user name and password of server. I am using SSRS report server 2019

Is there any way to pass username and password in report URL from UI?

If not how to fix this credential popup issue ?

User's image

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
10,613 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,798 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,121 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,741 Reputation points
    2023-02-06T11:49:25.2766667+00:00

    Which browser are you using?

    Some don't pass the current Windows credentials to SSRS, then you have to enter them.

  2. AniyaTang-MSFT 12,311 Reputation points Microsoft Vendor
    2023-02-07T01:40:51.17+00:00

    Hi @Amit M

    Browsers support specific authentication schemes that must be handled by the report server for client requests to succeed. You can check this link to check the required authentication requirements for your browser: Authentication requirements.

    In addition, you can also try to add the URL to trusted sites, please check this link for details: https://learn.microsoft.com/en-us/answers/questions/164528/how-to-troubleshoot-ssrs-prompting-for-user-name-p.

    Best regards,

    Aniya

    0 comments