DataGrip on Mac to MSSQL 2016 server w/ win auth

Trying to connect to MSSQL 2016 from DataGrip and Mac client.
Can't get it to work. Tried both jTds and the Microsoft driver.

I read that the microsoft driver doesn't support win auth on mac.
So this post will include what I have tried with jTds.

I have verified that I can connect the the database with my auth info from other programs (including a half finished golang driver)
But I am having no luck from DataGrip on Mac, and the error messages aren't that verbose either.

So I have the following extra settings:

USENTLMV2 = true
DOMAIN = DOMAINNAME

And the regular host/user/pass info.

The only caveat is that I connect against a hostname that is NAT:ing to the real host.
But this works on other programs I have tried.. So shouldn't be the issue.

Tried putting username both as DOMAIN\USER and just USER (since DOMAIN is all ready set in options).


The error I get is:

I/O Error: DB Server closed connection.

 

So it's not very verbose.
Anyone have any input on this?

Thanks!

Best Regards
Anders Wallin

0
3 comments
Official comment

You can find information concerning your problem in our blog post

UPD: I updated the link.

 

The link in the response is no longer valid

0

UPD: I updated the link.

0

Please sign in to leave a comment.