How do I get rid of this authentication prompt?

Rubina Akter 21 Reputation points
2021-04-11T14:14:46.79+00:00

Hi, I am getting this prompt every time I try to access reports -a week ago I was not being prompted . What can I do to allow access without having this prompt ?Please help urgently.
86623-authentication-prompt.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.
2,117 questions
No comments
{count} votes

Accepted answer
  1. Dave Patrick 329.9K Reputation points Microsoft MVP
    2021-04-11T14:30:56.553+00:00

    The simplest solution I've found is to use an sql user in the report's data source connection. Then you can store the credentials in the data source stored on the SSRS server.

    --please don't forget to Accept as answer if the reply is helpful--


1 additional answer

Sort by: Most helpful
  1. ZoeHui-MSFT 18,896 Reputation points Microsoft Employee
    2021-04-12T01:35:33.61+00:00

    Hi @Rubina Akter ,

    You may also refer this for more details about the Credential and Connection Information for Report Data Sources.

    Please feel free to let me know if you have any other issue.

    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

    No comments