Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

   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.

share|improve this question

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

share|improve this answer
DBVisualizer has a very nice diagramming graph layout for showing table references. IMHO better than SSMS at least for visualising – BozoJoe May 17 '13 at 0:39
@BozoJoe nonetheless, it'd probably still be better for OP to contact DBVisualizer support. – swasheck May 17 '13 at 2:43

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

(Pick the 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.

share|improve this answer

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:

share|improve this answer

Please find dbvis.vmoptions in c:\Program Files\DbVisualizer and add following option there


just after the line


share|improve this answer

Knowing by default newer SQL Server builds keep the TCP communications off whereas JDBC and jTDS require it I went ahead and enabled TCP in Configuration Tools -> Configuration Manager. In SQL Server Network Configurations -> Protocols I enabled the TCP protocol and then was able to connect.

Image for reference

share|improve this answer

Your Answer


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.