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

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.

 

7 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 September 6, 2012 at 1:13 pm #

    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

    • ittichai September 6, 2012 at 1:55 pm #

      That’s what I did when I wrote this post. :-) Thanks.

  2. merlin samy September 9, 2012 at 7:26 am #

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

  3. Ankit January 25, 2013 at 5:55 am #

    Hi ,

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

  4. Brandon March 22, 2013 at 1:18 pm #

    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 May 14, 2013 at 3:05 pm #

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

  6. Oracle Training in Chennai October 28, 2014 at 3:20 am #

    This website is very helpful. thanks for shearing it with us.

Leave a Reply

Powered by WordPress. Designed by WooThemes