Login via AAD not working for me
Today i installed the latest EAP and checked the new function to connect to an Azure SQL instance via Azure Active Directory login. I will get the following error:
The same logon via SQL Server Management Studio works perfect.
I'm working in Home office and be connected via VPN to my corporate network. The login to azure is secured via two factor authorization. But the second factor is only requested when i try to login outside the corporate network.
I'm not sure if it's a bug in Datagrip or the adal4j library or a configuration issue.
Regards
Andreas
Please sign in to leave a comment.
>The same logon via SQL Server Management Studio works perfect.
SSMS uses native tools to access to Azure (not Java).
> But the second factor is only requested when i try to login outside the corporate network.
According to your error code AADSTS53003 you didn't meet conditional access policy .
Could you review your Azure activity sign-in activity report?
Additionally, according to an article it could be that "unknown client application (in our case DataGrip) is blocked".
Hello Vasily,
thank you for the quick answer. I don't have administrative access to the AAD so I have to contact our helpdesk. I hope they could help me faster with the information you gave me.
Thanks
Andreas