« 
 »
31 05 2009

Enable TCP/IP on SQL Server 2005 Express Edition

Posted by: andreiash 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:

  • SQL Server 2005 named instance in Oracle SQL Developer
  • Book review: SQL Developer 2.1 by Sue Harper (Packt Publishing)
  • I’m going to review one/some Packt book(s)
  • SQL Developer 2.1 EA1 available
  • Windows authentication connection to SQL Server from SQL Developer
    • 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.

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

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

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

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

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

      Thanks, you saved the day.

    4. Johan 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 [...]

    Leave a Reply