DataGrip Azure Multi-factor authentication

已回答

Hi,

I am trying to connect to an Azure DB, however my account is configured to use Multi-factor authentication (MFA). In SQL Server Manager I connect using a method called 'Azure Universal Authentication'. (https://docs.microsoft.com/en-us/azure/sql-database/sql-database-ssms-mfa-authentication).

I've tried connecting using the latest microsoft jdbc driver, but end up getting the error:
Error code 0xCAA2000C; state 10.

Which says I need to use MFA.

Is it possible to connect in this way using DataGrip? Or what are my options?

Thanks

11

Can you please provide a timeline to when you will support MFA? '

I can also no longer use JetBrains software (PhpStorm - which I love) as you don't support MFA. A little more transparency than "we don't support it" would be greatly appreciated!

 

Thanks!

5

Its been almost a year, any word on AD MFA support?

1

@Vasily Generated a one time password and tried a couple different ways with both the microsoft and tJds flavors but no luck so far.

1

Is there any update on Datagrip support for MFA? It has been over two years since this issue was brought up. I am trying to log in to our Azure DBs since I turned on MFA for compliance issues, and I am stuck using Microsoft's SQL Server Management Studio. I would love to use DataGrip instead. 

1

I need to concur with Zuriel here, I'm using JetBrains tools for almost everything (and LOVING it) and I would love to be able to use DataGrip as well.  For me, this is a pretty large hole in my development chain.  SSMS is... just... well, BAD.   Please?  I'm not above begging.

 

Thanks,

-- Matthew

3

It's a great pity AAD MFA isn't supported. DataGrip is a great tool that I have been happy to pay for.

For anyone who is interested, I have just logged in to an Azure SQL Database using Microsoft's Azure Data Studio (on a Mac). ADS just connected me to a web browser window where I could select my Microsoft account. It provided me with the code to enter.

2

Here is feature request on our tracker, please follow and vote.

0

is this still not supported? this has been over years now

0

Good news, Microsoft finally updated their JDBC driver this month and JB implemented the Azure Active Directory interactive authentication in the latest EAP build for 2021.1.  https://blog.jetbrains.com/datagrip/2021/02/19/datagrip-2021-1-eap-2/ 

0

This still doesn't work if you have a "personal" Microsoft account and 2FA/MFA enabled.  

0

jaredbaszler,
Could you try to run sample project in IDEA Community Edition https://github.com/DataGrip/Test-MS-ActiveDirectoryInteractive (don't forget to replace REPLACE_ME strings with proper values)? I would help us eliminate issues with logins/passwords and focus on real issue if it is in DataGrip.

0

 

I was able to connect. ;)

0

请先登录再写评论。