I recently installed SQL Server 2005 Express Edition (don’t ask) and wanted to get it to listen on a TCP/IP socket as well (this is by default off, go Microsoft!). I enabled TCP/IP sockets in the configuration editor, but it didn’t work. There was a listener on 1026/tcp (?) but not on 1433/tcp. Google’s first few hits only told me what I had already done, but the Microsoft Knowledge Base item on the second results page pointed me in the right direction: the "SQL Browser Service" must be enabled and running. It seems to be disabled in the default (Express Edition at least) install.

• An Interview With Dr. Wallace J Nichols, Blue Marbles Project Founder
  Technorati's exclusive interview with Ocean Biologist Dr. Wallace J. Nichols, founder of the Blue Marbles Project.
• About Antioxidants
  Antioxidants, ORACs and free-radicals, oh my!
• Ministers Caught Watching Porn in the Legislative Assembly
  Two Karnataka BJP ministers caught watching porn film in Legislative assembly
• From Titanic to Concordia
  A Century After the Titanic Disaster, A Rush to Compare the Costa Concordia's Fate
• South's Tallest Skyscraper Sold At Auction Today
  BofA Plaza Not in Distress, but Disgusted