Take the 2-minute tour ×
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. It's 100% free, no registration required.

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.

share|improve this question

3 Answers 3

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
1  
@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:

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.

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:

sqljdbc_4.0\enu\auth\x64\sqljdbc_auth.dll
share|improve this answer

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.