SQL Developer 3 - Connecting to SQL Server Using Third Party Drivers

SQL Devleoper 3 is here. Today I downloaded the early adopter version and am intent on connecting to a local SQL Server database to extract some support information.

Documentation on this process is contained in the online manuals located here

http://download.oracle.com/docs/cd/E18464_01/doc.30/e17472/dialogs.htm#s...

Here's a Quick How To Connect SQL Devleoper 3 to SQL Server or MySQL

Note that you can use "Check For Updates" to locate the available drivers.

Here's the steps I followed.

Click Help->Check For Updates

Then check the boxes to enable Oracle Extensions and Third Party SQL Devleoper Extensions

In the list scroll down to

JDTS JDBC Driver 11.1.58.17

check the box

If you need MySQL support that driver is right below and is named

MySQL JDBC Driver 11.1.58.17

Click Next

Accept the GNU Lesser License Agreement

Click Next

and the drivers will download

Restart SQL Developer

Now Click Tools->Preferences->Database->Third Party Drivers

In the Browser box you will see a couple of folders, one should be 'tmp'

Browse into Temp and open the update folder

The drivers you downloaded are there

Now if you get a message that says

java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded.

You are missing a DLL.

Goto this address at SourceForge and download the missing DLL

http://sourceforge.net/projects/jtds/files/jtds/1.2.5/jtds-1.2.5-dist.zi...

Browse into the zip file and find a file named

ntlmauth.dll

Put that anywhere in your path and restart SQL Developer.

You will be all set and should be able to login using NT Authentication