can't connect to SQLEXPRESS locally

I have SQLEXPRESS installed on a Windows 2003 Server. The SQL Tools show that TCP and Named Pipes are Enabled. I can't connect using either the command line or the Mgmt Studio with either of these protocols.

Following is excerpt from program I'm trying to install:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

And this from the command line

C:\Documents and Settings\edulog>sqlcmd -E -S localhost
HResult 0x274D, Level 16, State 1
TCP Provider: No connection could be made because the target machine actively re
fused it.

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

Thanks,

That's expected. Enable shared memory and you'll be good to go.

Paul

|||The MS documentation ( in the SQL Server Express Readme) says shared memory is enabled by default. I am trying to connect locally, and have named pipes, and tcp enabled as well as shared memory. All 3 methods fail.

Wendell