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

3 comments
Comment actions Permalink

>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?

 

0
Comment actions Permalink

Additionally, according to an article it could be that "unknown client application (in our case DataGrip) is blocked".

0
Comment actions Permalink

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

1

Please sign in to leave a comment.