Cannot connect to MS SQL 2008 R2 by DBVisualizer. “Native SSPI library not loaded” error

Question

I try to connect to MS SQL 2008R2 database by DBVisualizer. I use jTDS driver, but following error occurs

An error occurred while establishing the connection:

Long Message:
I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.

Details:
   Type: java.sql.SQLException
   SQL State: 08S01

I added ntlmauth.dll to jre/bin but it didn't help. I have java 1.6.0_25.

Answer 1

This isn't a really widely used tool for SQL Server database administrators. For better answers, I'd contact DBVisualizer's support.

Answer 2

Download the jTDS driver from the following web site as it contain the needed files:

http://sourceforge.net/projects/jtds/files/

(Pick the jtds-1.2.5-src.zip file).

Unpack it and then read the README.SSO file.

In order for Single Sign On to work, jTDS must be able to load the native SPPI library (ntlmauth.dll). Place this DLL anywhere in the system path (defined by the PATH system variable) and you're all set.

Answer 3

If your using the sqlJDBC4 driver you have to jump through an extra hoop.

Once you have used the DBVisualizer "Driver Finder" you need to place the correct sqljdbc_auth.dll (x86 vs x64) in the jre/bin directory used by DBVisualizer. In my case I use the 64 bit DBVisualizer with an embedded jre. so my directory is:

C:\Program Files\DbVisualizer\jre\bin

which means I needed to copy from:

sqljdbc_4.0\enu\auth\x64\sqljdbc_auth.dll