/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 vote206 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
-1 vote200 views1 answer
How to use update trigger in sql
SQL
1 vote214 views1 answer
Postgres select as csv
SQL
6 votes208 views1 answer
How to count number of rows in sql
SQL
1 vote214 views1 answer
Get all db sizes in mysql server
SQL
0 vote225 views1 answer
Mysql update set sum
SQL
19 votes231 views5 answers
Date between in mysql
SQL
17 votes222 views6 answers
Current date in sql
SQL
22 votes224 views4 answers
Mysql reset auto increment id
SQL
0 vote228 views2 answers
PostgreSQL having
SQL