SSRS Report Builder - Data Set Prompting for Password

VS29 246 Reputation points
2022-04-15T20:49:08.513+00:00

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!

Azure SQL Database
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,869 questions
0 comments No comments
{count} vote

2 additional answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,571 Reputation points
    2022-04-18T03:21:01.697+00:00

    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.

    1 person found this answer helpful.
    0 comments No comments

  2. VS29 246 Reputation points
    2022-04-18T12:57:35.71+00:00