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.