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 »