Question :
Does anyone know when support for Active Directory – Universal with MFA will be included in Reporting Services?
It’s available in SSMS.
Visual Studio 2017 Data Source Properties
Reporting Server Data Source Properties
Answer :
The MFA auth flow is interactive. For me, for instance, it opens a browser window, displays an code, and I get a notification on my phone to approve the login.
So you can’t use it in background services like SSRS.
Use OLEDB connector and type the connection string directly:
Provider=MSOLEDBSQL;Data Source=myServer;Initial Catalog=myDatabase;Authentication=ActiveDirectoryInteractive;User ID=myUserName;Use Encryption for Data=true;