AzureAD Interactive Authentication

AzureAD Interactive Authentication

Hi,

I'm attempting to get AzureAD Interactive Authentication (auADInteractive) working with SDAC connecting to a SQL Azure database.

At the moment it always asks for my password and then a two factor auth challenge. This happens every time I start the app.

SSMS does not ask after the initial login, even when it's closed and restarted. And in the .Net world using Microsoft.Data.SqlClient all I get is a popup to select my account with no password or challenge.

I was wondering if I there was something I could change in SDAC to make the experience easier on our users?

Thanks, Luke.