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.

Incoming Links (via Technorati):
Nothing Reported