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:

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

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.

3. Restart SQL Server Express service.

4. Try again from SQL Developer. This time will work!

Good luck,

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:


  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 ?


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