DataGrip Azure Multi-factor authentication
Answered
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
Please sign in to leave a comment.
Yes, MFA is supported in DataGrip 2021.1 EAP 2
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!
Its been almost a year, any word on AD MFA support?
@Lasstlos One time password implemented in DataGrip 2017.3 https://blog.jetbrains.com/datagrip/2017/12/06/datagrip-2017-3/#connectivity .
@Vasily Generated a one time password and tried a couple different ways with both the microsoft and tJds flavors but no luck so far.
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.
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
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.
Here is feature request on our tracker, please follow and vote.
is this still not supported? this has been over years now
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/
This still doesn't work if you have a "personal" Microsoft account and 2FA/MFA enabled.
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.
I was able to connect. ;)