Posts Tagged “sql server”

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:
2009-05-31_1408

In ordrer to enable TCP/IP you have to do a few steps:
Read the rest of this entry »

Tags: , , , ,

Comments 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: , , , , ,

Comments 3 Comments »