Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Wednesday, May 02, 2012

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 or from
    (Please download the distribution, and not the source - ex: - 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
Once one of the both previous step has been successful, create your new SQL Server connection:


No comments: