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
请先登录再写评论。
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.