How To Create a Connection With SQL Server In SQL*DEVELOPER

Ensure that the source database is accessible by the Microsoft SQL Server user and the system from where you are connecting that is used by SQL Developer for the source connection.You can test by creating the ODBC datasource to the SQLServer DB.


In SQL*Developer, create a new SQL Server connexion. If you can't see the 'SQL Server' tab in the suggested database (Example: you only see Oracle and Access), please execute following steps to automatically load the JDBC driver for MS SQL server:

1. Go to the Help menu and select Check for Updates
2. Follow the Check for Updates Wizard.
3. In the Source step, select only the 'Third Party SQL Developer Extensions' option and click on Next button
4. In the Updates step, select 'JTDS JDBC Driver for Microsoft SQL server' option and load the updates.
5. You will be asked to read and acknowledge the license agreement and sign into OTN, using your OTN account.
6. When prompted, restart SQL Developer
7. There is no need to select "Migrate User Settings" dialog as the connections and settings are preserved.

If, unfortunately, you can't use successfully the Check for Updates, you can try to manually load the JDBC driver:

1. Downloaded the JTDS JDBC driver from http://jtds.sourceforge.net/ or from http://sourceforge.net/project/showfiles.php?group_id=33291.
   (Please download the distribution, and not the source - ex: jtds-1.2.5-dist.zip) - Unzip the file in a directory you can create independently from SQL Developer - You have to get  a .jar file  (ex: jtds-1.2.jar).
2. In SQL*Developer , click Tools/Preferences, then Database, then Third Party JDBC Drivers.
3. Click Add Entry.
4. Select the jar file (ex: jtds-1.2.jar). for the JTDS driver you downloaded from http://jtds.sourceforge.net/

Once one of the both previous step has been successful, create your new SQL Server connection:





Ref:471882.1