Friday, January 28, 2011

Connecting to SQL Server using SQL Developer

Problem:
Need to connect to SQL Server Database using SQL Developer

Solution:
This is an option available under SQL Developer which will allow us to connect to Third-Party Database systems. If we configure our SQL Developer, we can connect to SQL Server database.

Below mentioned are the steps which will ensure SQL server connectivity:
1) You need to have a Jar file in place for SQL server.
2) Download jTDS SQL Server driver - an open source JDBC driver from:-'http://sourceforge.net/projects/jtds/' to your local drive.
3) Unzip the folder
4) Open SQL Developer
5) Goto Tools -> Preferences -> Database -> Third Party JDBC Drivers
6) Click 'Add Entry', navigate to the unzipped folder
7) Select jtds-1.2.5.jar and click OK
8) Now goto the connections window and create a new connection
9) Give some connection name, enter proper username and password
10)Select 'SQLServer' Tab
11)Enter proper Hostname and leave Port as 1433 (Default). Change the port number only if it is running on running on some different port.
12)Click on Retrive Database button to fetch the Database name you want to connect
13) Test the connection
14) SUCCESS, Save the connection and press the connect button

It works!!!

13 comments:

strat said...

Thanks for the method given. This is such a useful guide.

salt lake fire systems

Abel M said...

Short, sweet, and simple. Thanks for the procedure. Works like a charm!!

melvin said...

Very Very Very useful post..
Thanks a ton

Ashok Aravind said...

greatly useful post...

Nge said...

we have backup server for our live DB. I can connect to live DB by doing the steps. But cannot connect to our backup DB. If I'm not wrong it's because the password for our backup DB is [blank]. Is there any way to connect to DB with blank password?

Nihar said...

Thanks for the instructions. It was really helpful.

Wardah said...

that's pretty easy but its not working for me i m doing exactly as you told any thoughts...
need thoughts

melvin said...

Thanks a lot.. Very helpful article.

triska said...

Nope, not working with the jTDS 3.0 version, or is it SQL Developer 3.2? I can't find a solution anywhere.

Unknown said...

I heard it works with jtds 1.2.7

SK said...

I am doing the exact steps mentioned in the Post but, the issue I am facing is that when I click on connections, the new connection pop -up window is not coming up for me.

When I remove the jtds-1.3.0.jar from the Tools--> preferences-->Database the pop-up for the new connection comes up.

Any Idea what is wrong ?

SK said...

It was version Mismatch.
Mine was Pl SQL Developer version Version 3.0.04 and support Jar version is jtds-1.2.jar

saurabh srivastava said...

can u please tell me what will be the host name and port ,currently I am using local host as host name and port as 1433 and check box checked is use window authentication but I am not able to connect .Please help me out