JetBrains DataGrip - Azure SQL - connect with Active Directory - Password

Question

Is it possible to connect to Azure SQL database the same way as I would with Microsoft SQL Management Studio - the "Active Directory - Password" option.

I followed the instructions from here (JetBrains documentation) but when I select "Use Windows Domain authentication" (as I should for Azure Active Directory) it doesn't let me to enter the credentials as SSMS does.

Everything works fine with SSMS but with DataGrip I have no luck. Is this option just not supported in there?

Answer 1

It's possible.

1. Use JTDS driver, not Microsoft one.
2. Go to the Advanced tab of data source properties, set USENTLMV2 to true and specify the domain name in the DOMAIN field.
3. Then enter your Active Directory credentials in user/password fields and click Test Connection.