« 
 »
29 05 2009

Windows authentication connection to SQL Server from SQL Developer

Posted by: Andrei in Database, Oracle

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.”
sqldev_winauth

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:

Related Posts

Sovrn
Tags: , , ,

This entry was posted on Friday, May 29th, 2009 at 9:01 pm and is filed under Database, Oracle.You can follow any responses to this entry through the RSS 2.0 feed.You can leave a response, or trackback from your own site.

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:
    July 6th, 2011 at 12:57 am

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

  2. ViniciusNo Gravatar says:
    October 28th, 2011 at 12:51 pm

    Nice tutorial! Thanks.

Leave a Reply