Authentication via Azure Active Directory Interactive does not work
Answered
I'm trying to login to an Azure SQL DB via AAD with MFA. In SSMS it works without problems, but Datagrip opens a localhost with random port number instead of the Microsoft login url. What could cause this problem?
Kond Regrads
Andreas
Please sign in to leave a comment.
Please upload IDE logs from Help -> Collect logs and diagnostic data here -> https://uploads.jetbrains.com/browse and provide me with upload id.
Unfortunately i had problems to use the upload service. Your URL leads to a Google login page which want's a jetbrains.com email address (and i don' t have a google account and will never create one). I entered the URL manually without "/browse" and then could select a file to upload. But the upload itself failed. So i submitted a Request (#3655821) with the requested log files.
Kind Regards
Andreas
Are there any updates on this topic? I'm having the same problems.
I've managed to solve this problem somehow.
I think I've just switched to "azure active directory password" option. Probably updated DataGrip for an EAP or something. But now it is now there for my 2021.3.1 version.
The problem is located in the Microsoft drivers. Login via MFA currently works only if the language of the Windows operating system is set to English. See https://github.com/AzureAD/microsoft-authentication-library-for-java/issues/492#issuecomment-1115094484
Just an update: The issue is now located in the Microsoft JDBC driver and there was opened an issue for it: https://github.com/microsoft/mssql-jdbc/issues/1839