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:

1. From SQL Server Configuration Manager, go and expand “Network Configuration”, choose “Protocols for SQL Server Express” and enable TCP/IP
2009-05-31_1412

2. Open TCP/IP properties page, go to the second tab “IP Addresses” and in the last field called “IPAll – TCP Port” enter your port number. You might want to choose 1433.
2009-05-31_14092

3. Restart SQL Server Express service.
2009-05-31_1410

4. Try again from SQL Developer. This time will work!
2009-05-31_1413

Good luck,
Andrei

Related posts:

Tags: , , , ,
10 Responses to “Enable TCP/IP on SQL Server 2005 Express Edition”
  1. JilaDiarraNo Gravatar says:

    Thanks a lot Andrei, that’s just the problem I encountered.

  2. andreiashNo Gravatar says:

    great! that was the idea, to share things that I came across with.

  3. Bogdan MihaiNo Gravatar says:

    Thanks, you saved the day.

  4. JohanNo Gravatar says:

    THANKS !!!

    I was looking for a solution for the SQL connection.

  5. links for 2009-12-03 says:

    […] Enable TCP/IP on SQL Server 2005 Express Edition » Andrei DANEASA (tags: sqlserver microsoft configuration) Interesting Links […]

  6. Graeme WantNo Gravatar says:

    Great answer. Solved my problem. Thanks.

  7. devarajNo Gravatar says:

    AWesomeeeeeeeeeeeeeee

  8. prasadNo Gravatar says:

    Great Answer.solved my problem…Thanks dude.

  9. aPNo Gravatar says:

    Great article!
    But if the button “Retrive database” does not appear, which may be the cause ?

    Thanks!

  10. Enable TCP/IP on SQL Server 2005 Express Edition to connect through java (Enable JDNI) | TootleCode says:
Leave a Reply