Sql Developer connector to Sql Server 2012 - error "Vendor code 207"

Question

I am trying to connect from Sql Develper 4.0.3.16 to Sql Server 2012, with jTDS connector jtds-1.3.1.jar.

OS: Ubuntu 14.04

Java:

~$ java -version
java version "1.7.0_72"
Java(TM) SE Runtime Environment (build 1.7.0_72-b14)
Java HotSpot(TM) 64-Bit Server VM (build 24.72-b04, mixed mode)

In the create connection window, when I test the connection it is successful.

When I open the connection I can see all the databases. When I try to open a database that I am supposed to have a permission to open, I am getting the following error window:

Any ideas?

P.S. if Microsoft has a JDBC driver sqljdbc4-4.0.jar (which works for me when I connect from Java code to Sql Server 2012), then why do I have to use jTDS in order to connect Sql developer to Sql Server? It seems like the Microsoft jdbc driver is not accepted by Sql Developer when I try to used it as a connector.

Before clicking on +

After clicking on +

Answer 1

As it's explained here, so far sql developer supports only up to sql server 2012. In my case I'm using 2014 version, which isn't supported.

UPDATE There've been several updates, which provide support to newer databases. Check them out, now I'm able to connect to my servers using SQL Developer.

Answer 2

Download latest version of Oracle SQL developer which works flawlessly to connect SQL server. Make sure you export all your connections before being downloaded the newer version which is 19.2, etc.