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
Comment actions Permalink

@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
Comment actions Permalink

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
Comment actions Permalink

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
Comment actions Permalink

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
Comment actions Permalink

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

0
Comment actions Permalink

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
Comment actions Permalink

You can several jar files, e.g.:

0
Comment actions Permalink

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

0
Comment actions Permalink

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

0
Comment actions Permalink

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

0
Comment actions Permalink

Any update on this?

0
Comment actions Permalink

@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
Comment actions Permalink

@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
Comment actions Permalink

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.