On SQL Server 2005 Express Edition (I don’t know how’s on full version, never had a license for it) the default connection model is through named pipes and TCP/IP is disabled.
If you want to connect to it from Oracle SQL Developer using jTDS driver it will throw a generic connection failure, as he is trying just TCP/IP. The error looks like this:

In ordrer to enable TCP/IP you have to do a few steps:
Read the rest of this entry »
Tags:
howto,
jtds,
sql developer,
sql server,
tcp/ip
10 Comments »
I’ve been told that there is no way to connect to a SQL Server 2005 named instance from SQL Developer. That’s not necessary true, but it’s strange.
A bit of background information: SQL Developer is connecting to SQL Server through JTDS opensource driver. The driver said that it cannot support named instances. On the other hand, in the connection string, there is a syntax for named instance, like “instance=your_instance“.
Read the rest of this entry »
Tags:
10g,
11g,
jtds,
oracle,
sql developer,
sql server
3 Comments »