/SQL/Sql developer connect to sql server

Sql developer connect to sql server

1. Download the jTDS 3rd party JDBC driver, version 1.2.8 from here https://sourceforge.net/projects/jtds/files/jtds/1.2.8/jtds-1.2.8-dist.zip/download 
2. Save and extract the contents of the jtds-1.2.8-dist.zip file somewhere safe (ex: “C:\oracle\sqldeveloper\add-ons\jtds-1.2.8-dist\”).
3. Start SQL Developer go to Tools > Preferences > Database > Third Party JDBC Drivers.
4. Click “Add Entry”, point to the ‘jtds-1.2.8.jar’ file location, then select it and click OK.
5. Create a new connection, and choose the “SQLServer” tab.
6. Enter the following details: Connection Name (required for database retrieval), Username, Password, Hostname, and Port.
7. Click “Retrieve database” and select the appropriate database, then Save/Test/Connect as you would do normally.

Source: snapdba.com

Similar codes

0 vote157 views1 answer
Expose db in virtualbox
SQL
13 votes208 views2 answers
Oracle select into and inner join
SQL
1 vote206 views1 answer
Md5 encryption for existing records
SQL
15 votes357 views2 answers
How to sort names in alphabetical order in sql
SQL
18 votes213 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote201 views1 answer
Mysql could not fetch tables
SQL
0 vote190 views1 answer
Oracle sql date summer time
SQL
0 vote204 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote196 views2 answers
Mysql multiply
SQL
0 vote244 views1 answer
Mssql find deadlocks
SQL