Microsoft SQL DatabaseLink connection using Windows Authentication from Mac



We know that Mathematic doesn't natively support Windows Authentication connect. But as we can see in this post, the problem can be easily solved when your Mathematica is in Windows version (I have just made it).

The company that I work is now changing to Windows Authentication, and the problem is that I use both Mac and Windows.


There is someway that I could connect into SQL Server database using Windows Authentication from my Mac Mathematica? So I could pass my Windows Domain/User and Password together with the jDBC connections string?

PS: I don't want to use Windows version of Mathematica in my Mac by Parallels, this will be my last shot.


Posted 2012-12-08T18:23:00.670

Reputation: 23 859

Have you tried updating the jTDS driver? Mathematica 9 includes jTBS 1.2.5 and the newest version is 1.3.0. Not sure if the newest version will include Windows Authentication support. – kale – 2012-12-09T01:54:37.187

Reading the Single Sign On README.SSO file included with the latest jTDS release, the Windows Authentication relies on the ntlmauth.dll to glean system information from the PC (Domain, username, etc.) and allows access to the database. So with the jTDS implementation, Mac SSO is not supported (I've tried the newest version here at home VNC'd in to the office). Possibly another 3rd party ODBC solution would include this support. – kale – 2012-12-09T21:25:16.440

But in the FAQ of jTDS I founded this, I'll test tomorrow: "Domain: Specifies the Windows domain to authenticate in. If present and the user name and password are provided, jTDS uses Windows (NTLM) authentication instead of the usual SQL Server authentication (i.e. the user and password provided are the domain user and password). This allows non-Windows clients to log in to servers which are only configured to accept Windows authentication."

– Murta – 2012-12-10T02:03:18.140

Yeah, I see that now. Just tried it but am still getting a warning about an untrusted domain. Might be because I'm on a VNC connection. Add the ";domain=whatever;user=username" and see if that works tomorrow. If so, I'll delete my useless comments. – kale – 2012-12-10T02:38:13.277

I don't know how to install/update to the jTDS 3.0 version. I'm waiting Wolfram Enterprise Support to see with they can help me. If I get something I'll put here. tks – Murta – 2012-12-11T00:00:56.710

No answers