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

6 comments
Comment actions Permalink

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.

1
Comment actions Permalink

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

 

1
Comment actions Permalink

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 

1
Comment actions Permalink

Please upload IDE logs from Help -> Collect logs and diagnostic data here -> https://uploads.jetbrains.com/browse  and provide me with upload id.

0
Comment actions Permalink

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

0
Comment actions Permalink

Are there any updates on this topic? I'm having the same problems.

0

Please sign in to leave a comment.