Tell me more ×
Mathematica Stack Exchange is a question and answer site for users of Mathematica. It's 100% free, no registration required.
up vote 10 down vote favorite
6

For those who use Mathematica with databases in companies, a common way to securely connect to those is using Windows Authentication (detailed here).

Mathematica doesn't seem to support this authentication method. How can you connect to a database securely using Windows authentication?

share|improve this question

1 Answer

up vote 12 down vote accepted

After much digging, I found this MathGroup archive detailing how to get Mathematica working with SQL servers protected by Windows authentication.

It's repeated here mainly for posterity's sake.

  1. Download the jTDS files from here: http://sourceforge.net/projects/jtds/files/
  2. Unzip and locate the ntlmauth.dll file in the appropriate folder (x64, x86, IA64).
  3. Copy this file to $InstallationDirectory under SystemFiles>Java>(appropriate Windows folder)>bin
  4. Restart Mathematica.

Let's hope Wolfram decides to include this in the next version.

share|improve this answer
Wow!.. this really works. I just implemented it in version 9. Tks – Murta Dec 8 '12 at 17:49
@Murta, I really hoped they implemented it in v9. It's crucial to a lot of us in enterprises. – kale Dec 8 '12 at 18:45
Unfortunately the answer is no. Now I have another challenge that is similar to your post in this question. – Murta Dec 8 '12 at 18:49

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.