# Microsoft SQL DatabaseLink connection using Windows Authentication

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?

-

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.

-
 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