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

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

17 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

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

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

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

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

0

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

0

@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

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

1

Please sign in to leave a comment.