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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Jim Smith

You additonal jar files and dlls for single sign-on See this thread

smitt

Answer

After reading the thread referenced by Jim Smith (thanks!), I wanted to copy the information to this thread...and update to state that these same steps work for SQLDeveloper 1.5.1 & SQL Server 2005. Don't miss step 5, if you want to enable NT Authentication.

{From referenced post}

Setting Up SQL Developer for MS SQL SERVER 2000

1) Install/Extract SQL Developer 1.2.1 in C:\Program Files\Oracle
Making the {$sqldevhome} = C:\Program Files\Oracle\sqldeveloper

2) Obtain the JDBC SQL SERVER Pluggin (jtds-1.2.2-dist.zip) from:
http://sourceforge.net/project/showfiles.php?group_id=33291&package_id=25350

3) Unzip jtds-1.2.2-dist.zip
Creates: jtds-1.2.2.jar
\x86\SSO\ntlmauth.dll

4) Copy the jtds-1.2.2.jar into:
{$sqldevhome}\jlib Directory.

5) Copy the the ntlmauth.dll dll in the \x86\SSO subdir into:
{$sqldevhome}\jdk\jre\bin\ntlmauth.dll

6) In SQL Developer:
Go to Menu "Tools"
- Preferences...
Expand the "[+] Database
Choose "Third Party JDBC Drivers"
Click "Add Entry"
Then Browse for your copy of "{$sqldevhome}\jlib\jtds-1.2.2.jar"
Note: Use the jar filename, not its parent directory for entry.

7) Restart SQL Developer and try your SQL Server 2000 (or SQL Server 2005) Connection

Marked as Answer by 657146 · Sep 27 2020

user10594152

It works - thank you.... :)

8579

Thank you for adding this explanation!

Roy Prowell III

This worked for me also. In my case, it took me a moment to find the jlib directory.

C:\Program Files\sqldeveloper\jlib

Once I have that figured out, it worked exactly the way that it used in on a previous laptop.

Thanks for the instructions.

694659

Thank you very Much... It Works..

Roy Prowell III

I think that it is not possible, but it never hurts to ask. Can SQL Developer running on Linux be configured to use Windows Authentication against an MS SQL database?

745391

I have a case when I need to connect using Windows authentication using a network username/password , I am on a another network

sqldeveloper is unable to do it,
because when you check windows authentication it disables the username/password field and tries the credentials of your machine

AguaData studio is able to do it, it accomodates domain/username other that your machine login for authentication

any ideas how to do it in sqldeveloper

Edited by: user1327538 on Apr 7, 2010 9:02 AM

1 - 8

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,424 views

SQL Developer

SQL Server Connection using Windows authentication

Comments

Post Details