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

Answered

The error I've gotten to is below. Does anyone have any suggestions on what needs to be fixed? I've replicated the settings I had in SMSS to get to that point, but from my googling about, it looks like we need to add the application to our Azure database, but our sys admin has no idea on what that entails.

1
22 comments

@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? 

 

0
Avatar
Permanently deleted user

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. 

 

0

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:




0
Avatar
Permanently deleted user

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

0

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

0
Avatar
Permanently deleted user

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.

0

You can several jar files, e.g.:

0

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

0
Avatar
Permanently deleted user

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

0
Avatar
Permanently deleted user

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

0
Avatar
Permanently deleted user

Any update on this?

0
Avatar
Permanently deleted user

@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.

0
Avatar
Permanently deleted user

@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.

0

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!

4
Avatar
Permanently deleted user

Thank you Cole Kelley, that worked!

0

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"}

0

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

0

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

0

Please sign in to leave a comment.