SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Server Connection using Windows authentication

657146Sep 8 2008 — edited Apr 7 2010

I would like to use SQL Developer (v1.5) to connect to a SQL Server 2005 instance using windows authentication. I have downloaded jtdw-1.2.jar and set it's path e as a preference in the TOOLS\Preferences Database\Third Party JDBC Driver dialog box.

I have been able to connect to SQL Server 2005 successfully if I use SQL Authentication and provide a user_id and password.

It is my preference to use windows authentication for the connection. However, when I try to connect I get the following error:

Failure - I/O Error: SSO Failed Native SSPI library not loaded. Check the java library path system property

I have no idea of what this means. I am not a java programmer and I am very new to Oracle in general so can anyone give me some straight forward directions as to what I am missing?

Thank you

This post has been answered by smitt on Oct 29 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 5 2010

Added on Sep 8 2008

#authentication, #server, #sql, #sql-developer

8 comments

14,563 views