SSRS Report Builder - Data Set Prompting for Password

Question

Hi,

I am having trouble accessing Az SQL Managed Instance via SSRS Report Builder with MFA Authentication enabled.

When I initially accessed the data source on report server , the "Test Connection" was successful. However, when I try to create a Data set it is prompting me for the credentials.

To circumvent this, I had to create a SQL Login and use those credentials to connect to SQL MI. Is there a way to use interactive authentication in SSRS ?

Please advise, TIA!

Answer 1

SSRS is a background service and does not support interactive MFA authentication.

Please consider to use Power BI instead where you can easily configure MFA.

Answer 2

Hi @VS29 ,
As @Alberto Morillo said, SSRS does not support interactive MFA authentication
For the authentication supported by SSRS, please refer to: Authentication with the Report Server.
Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

Answer 3

Thank you @Alberto Morillo and @Joyzhao-MSFT !!