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
Please sign in to leave a 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
UPD: I updated the link.