sql-serveroracle-sqldeveloper

Connect SQL Server from SQL Developer


I searched through all threads on the web available, but none could help me.

I am trying to connect to SQL Server engine from SQL Developer. In order to do that I enabled Named Pipes and TCP/IP from SQL Configuration Manager.

Then I tried different drivers:

Is there anything more I can do?

EDIT

This is what I have so far:

enter image description here

SECOND EDIT

I had more problems:

  1. With error saying

    Status: Failur-I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property

  2. Using windows authentication, I still got asked for username and password.

(All details and solutions in my answer below)


Solution

  • We only support the jTDS driver for SQL Server and Sybase ASE connections, so that's the way to go.

    After that, it's up to you to get a correct connection string to your SQL Server system.

    Make sure you have the right port in addition to your 'localhost' network location for your SQL Server instance.

    This is using version 19.1 of SQL Developer to connect to a SQL2012 instance overseas..

    enter image description here