Trying to connect to SQL Server 2000 or 2005 from Oracle SQL Developer having Windows Authentication enabled on SQL Server will fail with:
“I/O Error: SSO Failed: Native SSPI Library not loaded. Check the java.library.path system property.”

The solution is simple: place a dll called NTLMAUTH.DLL (NT authentication) in your system path and restart SQL Developer. Windows/System32 is always a wise choice.

Where to get this DLL? It is shipped with JTDS here.

Is there another option? Yes, enable SQL Server authentication.

Related posts:

Tags: , , ,
2 Responses to “Windows authentication connection to SQL Server from SQL Developer”
  1. OraExplorer » SQL Developer with “I/O Error: SSO Failed: Native SSPI library not loaded” when connecting to MS SQL using Windows Authentication says:

    […] to a MS SQL database using Windows Authentication. Fortunately, couple web sites (here and here) already mentioned about […]

  2. ViniciusNo Gravatar says:

    Nice tutorial! Thanks.

Leave a Reply