Jul 05 2011

SQL Developer with “I/O Error: SSO Failed: Native SSPI library not loaded” when connecting to MS SQL using Windows Authentication

Category: SQL Developerittichai @ 5:57 pm

I encountered this error “I/O Error: SSO Failed: Native SSPI library not loaded” when using Oracle SQL Developer connecting to a MS SQL database using Windows Authentication. Fortunately, couple web sites (here and here) already mentioned about this.

Error when using SQL Developer to connect to MS SQL using Windows Authentication

Basically, from the  jTDS distribution downloaded files, I have to copy a DLL file named ntlmauth.dll (which is for NT authentication) under the jtds-x.x.x-dist\x86\SSO\ or jtds-x.x.x-dist\x64\SSO\, to any directories in the PATH environment. I copied it to the bin directory of the JDK (which I already have it in the PATH). Then after restarting the SQL Developer, I can now connect to MS SQL database using Windows Authentication.

 

6 Responses to “SQL Developer with “I/O Error: SSO Failed: Native SSPI library not loaded” when connecting to MS SQL using Windows Authentication”

  1. Kevin says:

    This information is very useful.

    If you are using Wndows 7 64 bit version, copy the jtds-1.2.6-dist\x64\SSO\ntlmauth.dll to a directory in the path. It will work.

    Thank you

  2. merlin samy says:

    Thanks a lot!!
    this information really helped me!!

  3. Ankit says:

    Hi ,

    What if I am using Windows 7 Ultimate 32 bit system ??
    Please reply.

  4. Brandon says:

    I got it working by copying NTLMAUTH.DLL into the \Windows\System32 folder instead of the JDK/Bin folder (C:\Oracle\sqldeveloper-3.1.07.42\sqldeveloper\jdk\jre\bin), then rebooting my PC. After my PC finished rebooting and I relaunched Oracle SQL Developer, it worked like a charm. I was able to access my SQL servers & databases successfully.

  5. Thien says:

    worked as Brandon suggested but no need to reboot PC (i only re-open SQL Developer) and was able to connect SQL Server succesfully.

Leave a Reply