Can't sign into Azure DB with Datagrip, but can with SMSS

@Melaniehopkins Could you send full IDE logs to me to vasily.chernov@jetbrains.com ? Also, what to you have in Advanced tab of your data source settings? 

Here is the settings in Advanced:

applicationIntent  readwrite
applicationName DataGrip
authentication ActiveDirectoryPassword
authenticationScheme nativeAuthentication
columnEncryptionSetting Disabled
databaseName 
disableStatementPooling true
enablePrepareOnFirstPreparedStatementCall false
encrypt true
failoverPartner 
fips false
hostNameInCertificate *.database.windows.net
instanceName 
integratedSecurity false
jaasConfigurationName SQLJDBCDriver
keyStoreAuthentication 
keyStoreLocation 
keyStoreSecret 
lastUpdateCount true
lockTimeout -1
loginTimeout 30
multiSubnetFailover false
packetSize 8000
portNumber 1433
queryTimeout -1
responseBuffering adaptive
selectMethod direct
sendStringParametersAsUnicode true
sendTimeAsDatetime true
serverName guidemedsrv.database.windows.net
serverNameAsACE false
serverPreparedStatementDiscardThreshold 10
serverSpn 
socketTimeout 0
sslProtocol TLS
statementPoolingCacheSize 0
TransparentNetworkIPResolution true
trustManagerClass 
trustManagerConstructorArg 
trustServerCertificate false
trustStore 
trustStorePassword 
trustStoreType JKS
workstationID 
xopenStates false

I also attached this to the email I sent. 

It looks like we're missing some additional jar files that are mentioned here https://docs.microsoft.com/en-us/sql/connect/jdbc/connecting-using-azure-active-directory-authentication?view=sql-server-2017#client-setup-requirements 

As a temporary workaround you need to add them to your Azure driver:

I'm having the same issue, but i'm not sure which files are needed from the specified link.

One of the files i found was the JDBC driver already in use by DataGrip. The other was a link to a github repository of an unbuilt library for Azure AD authentication.
Could you please specify the jar files mentioned?

Best regards

I am getting the same issue from the first post ... even after I loaded the extra drivers. Any workaround?

I'm using ActiveDirectoryPassword as authentication, which gives me "com/microsoft/aad/adal4j/AuthenticationException".

The links listed above have lead me to the Github page for adal4j, but i've been unable to build the jar file with all dependencies. I've spent an evening trying to get the maven build script to work, but as i'm not a java developer my knowledge of that build flow is very limited.

If somebody has the built jar file (or if the jar file could be included in DataGrip) I would be very grateful.

You can several jar files, e.g.:

I now get this error ... will Jetbrains be coming out with a fix soon? 

any information about how this can be resolved? what additional files need to be imported? it's very unclear what to do

@Jukub Holovsky Follow articles in comment https://intellij-support.jetbrains.com/hc/en-us/community/posts/360000014000/comments/360000029259

@vasily yeah but the comment is quite unclear, what additional JAR files are we supposed to load?

Any update on this?

To connect with AD read:
https://docs.microsoft.com/en-us/sql/connect/jdbc/connecting-using-azure-active-directory-authentication?view=sql-server-2017#set-kerberos-ticket-on-windows-linux-and-mac

@Vasily Chernov,

Could you give us a hard link to the exact package you need us to include? If you can't give us a link, could you explain why?
I would really like to use DataGrip with azure DB's, but you're not making it easy.

@Vasily Chernov,

Yes, we are all having the exact same problem. Please post steps 1, 2, 3 ... seems like you know what we are all talking about.

I was able to set up a connection on Mac OS. I wrote a step-by-step How-To that should work for all OSes.

https://codejuicer.com/2018/08/29/datagrip-and-azure-sql-server-active-directory-howto/

I hope this helps!

Thank you Cole Kelley, that worked!

Followed Cole's guide and did not work. I get the following.

The specified database user/password combination is rejected: com.microsoft.aad.adal4j.AuthenticationException: {"error_description":"AADSTS50076: Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication to access '022907d3-0f1b-48f7-badc-1ba6abab6d66'. Trace ID: b3867d09-0dfb-42a4-bca0-3d5bf7b8a500 Correlation ID: d8819385-6c56-4cd8-8f5e-77f4b335780b Timestamp: 2020-06-01 08:39:21Z","error":"interaction_required","error_uri":"https:\/\/login.windows.net\/error?code=50076"}

Hello vasily chernov, for a paid product the support is a bit lacking. Don't you think? People are paying you guys to do the stuff you are describing here in a very vague way. Please release a version with those jar files in the product. Otherwise, stop selling this. This in not an open source project! People are paying money for it. //:cc Hadi Hariri

@... Thanks for the ping. Will follow-up internally. 

@...,

Follow the issue https://youtrack.jetbrains.com/issue/DBE-8312 to get updates.