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:
Thanks for the method given. This is such a useful guide.
salt lake fire systems
Short, sweet, and simple. Thanks for the procedure. Works like a charm!!
Very Very Very useful post..
Thanks a ton
greatly useful post...
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?
Thanks for the instructions. It was really helpful.
that's pretty easy but its not working for me i m doing exactly as you told any thoughts...
need thoughts
Thanks a lot.. Very helpful article.
Nope, not working with the jTDS 3.0 version, or is it SQL Developer 3.2? I can't find a solution anywhere.
I heard it works with jtds 1.2.7
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 ?
It was version Mismatch.
Mine was Pl SQL Developer version Version 3.0.04 and support Jar version is jtds-1.2.jar
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
Post a Comment