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.
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”
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.
That’s what I did when I wrote this post. 🙂 Thanks.
Thanks a lot!!
this information really helped me!!
What if I am using Windows 7 Ultimate 32 bit system ??
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.
worked as Brandon suggested but no need to reboot PC (i only re-open SQL Developer) and was able to connect SQL Server succesfully.
This website is very helpful. thanks for shearing it with us.