sql server – Azure Data Studio ‘login failed for user ” with MFA Support authentication
While trying to set up access for a user to access a SQL Server via Azure Data Studio, they are receiving the following error message:
'login failed for user '<token-identified principal>'
The authentication type is ‘Azure Active Directory – Universal with MFA Support’ (and the ‘Account’ for the user is found), the database to access has been specified, Encrypt is set to true and the Trust server certificate is set to true.
I’ve doubled checked to ensure there isn’t more than one instance of this user in the AAD. No other users are having this issue. And I tried looking for solutions online for this, but I was unable to find any scenario like this.
Read more here: Source link
