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 thoughts on “SQL Developer with “I/O Error: SSO Failed: Native SSPI library not loaded” when connecting to MS SQL using Windows Authentication”

  1. 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. 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.

  3. 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 to Thien Cancel Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top