Testing DataGrip for our dev team and having difficulties connecting to our cloud sql server using Azure Active Directory auth.
Azure data studio works fine using Azure Active Directory - Universal with MFA support auth type.
If i try Azure Active Directory interactive, it opens ~20 tabs in Edge browser (localhost:xxxxxx) where each tab says "Authentication complete. You can close the browser and return to the application." before giving up with the following error:
Failed to authenticate the user email@example.com in Active Directory (Authentication=ActiveDirectoryInteractive). javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
Switching to Azure Active Directory password mode, it just fails with the similar error:
Active Directory (Authentication=ActiveDirectoryPassword). javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
I've tried to add all the certificates i found on this page (Azure Active Directory certificate authorities - Microsoft Entra | Microsoft Learn) to DataGrips trust store (Files->settings->Tools->Server certificates), didn't help, still the same error above. I've tried to add those certs into \JetBrains\DataGrip 2022.3\jbr\lib\security\cacerts, nothing. I've tried to enable SSL in SSH/SSL tab with each cert just for shits and giggles, got a different error but to be honest i'm pretty sure i'm doing something wrong here to begin with:
ava.security.NoSuchAlgorithmException: Error constructing implementation (algorithm: Default, provider: SunJSSE, class: sun.security.ssl.SSLContextImpl$DefaultSSLContext)
Would you know what's happening and how to fix this? Let me know if you need any other info.