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--
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
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--
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