SQL Server is a relational database management system by Microsoft Corporation. You need the Microsoft SQL Server Management tool to connect and work with SQL Server. But, you can use also SQL Developer to connect SQL Server using JDBC Driver called jTDS 3rd party JDBC driver.
What is jtds- SQL server and sybase jdbc driver?
jTDS – SQL Server and Sybase JDBC driver is an Open source JDBC 3.0 type 4 driver for Microsoft SQL Server (6.5, 7, 2000, 2005, 2008, 2012, 2017) and Sybase Adaptive Server Enterprise (10, 11, 12 and 15).
Use SQL Developer to Connect SQL Server
Download jTDS – SQL Server and Sybase JDBC driver from this location and unzip in on local drive preferably in the SQL Developer folder only. Now, start SQL Developer and go to Tools > Preferences > Database > Third Party JDBC Drivers.
This opens a window as shown below.
Click the Add Entry… button and select the jtds-1.3.1.jar file from the jtds-1.3.1-dist folder and then click OK to exit the preference window.
Now, create a new connection to the open database connection Window. Enter Name and select Database Type as SQL Server. You may have noticed that now there are 3 database types Oracle, SQLServer, and Sybase.
Enter username, password, hostname, and port. The default is 1433 which works fine unless the SQL server is listening on a different port.
Click the Retrieve Database button.
This populates all the available databases. Select the one which you want to connect and click Test Connection. You should be able to connect SQL Server.
Now click the connect button. This opens a SQL Editor from where you can run queries against MS SQL Server.
Here you go, you have successfully connected the SQL server from SQL Developer. One point to remember here, some of the native functionality available in Microsoft SQL Server Management Server will not be available.
I hope you liked this small tip. Please share and Subscribe.