« 
 »
29 05 2009

Windows authentication connection to SQL Server from SQL Developer

Posted by: andreiash 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:

  • Oracle SQL Developer Data Modeling 1.5.1 Early Adopter release launched
  • Oracle SQL Developer 1.5.1 is out
  • Upgrade Oracle APEX 3.2.1 to 4.0.1 on Oracle Database 10g Express Edition (XE)
  • Oracle Database 11g Release 2 available on Windows… finally
  • Book review: SQL Developer 2.1 by Sue Harper (Packt Publishing)
    • 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. Vinicius says:
      October 28th, 2011 at 12:51 pm

      Nice tutorial! Thanks.

    Leave a Reply