« 
 »
31 05 2009

Enable TCP/IP on SQL Server 2005 Express Edition

Posted by: Andrei in Database, Oracle

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:

Related Posts

Sovrn
Tags: , , , ,

This entry was posted on Sunday, May 31st, 2009 at 2:38 pm and is filed under Database, Oracle.You can follow any responses to this entry through the RSS 2.0 feed.You can leave a response, or trackback from your own site.

10 Responses to “Enable TCP/IP on SQL Server 2005 Express Edition”
  1. JilaDiarraNo Gravatar says:
    July 16th, 2009 at 2:01 pm

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

  2. andreiashNo Gravatar says:
    July 16th, 2009 at 10:48 pm

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

  3. Bogdan MihaiNo Gravatar says:
    September 30th, 2009 at 3:20 pm

    Thanks, you saved the day.

  4. JohanNo Gravatar says:
    October 21st, 2009 at 11:33 pm

    THANKS !!!

    I was looking for a solution for the SQL connection.

  5. links for 2009-12-03 says:
    December 3rd, 2009 at 11:05 pm

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

  6. Graeme WantNo Gravatar says:
    September 30th, 2012 at 12:45 am

    Great answer. Solved my problem. Thanks.

  7. devarajNo Gravatar says:
    February 12th, 2013 at 8:27 am

    AWesomeeeeeeeeeeeeeee

  8. prasadNo Gravatar says:
    March 5th, 2013 at 2:31 pm

    Great Answer.solved my problem…Thanks dude.

  9. aPNo Gravatar says:
    May 10th, 2013 at 5:08 pm

    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