After Install, "Running sqlcmd -S Server\Instance" Fails

I'm trying to figure out how to set up SQL Express so I can start learning SQL. I've installed SQL Express, but when I type "sqlcmd -S Server\SQLExpress," I receive the following error:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Username>sqlcmd -S Server\SQLExpress
HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
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.




Hi,

see the screencast on my site for eabling remote connections.

HTH, Jens K. Suessmeyer.

-
http://www.sqlserver2005.de
-

|||Thanks, but when I got to http://www.sqlserver2005.de/Screencast/Screencast.aspx?ScreencastId=1, nothing happened.

I've found how to enable remote connections in the KB. So I have to enable remote connections to access SQL Server on a local computer? Want I want to do is get some sort of IDE up to learn in. Thanks.|||The screencast is a flash file, so you will need to have flash installed on your computer.

If you navigate through the Surface Area configuration (presented in the program menu) > Services and connections, you can change the setting, make sure you restart the service afterwards.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||Thanks. I will point out that Flash is installed in my computer though, and about:plugins shows "Shockwave Flash." I've tested Flash on other sites, it pulls up fine.|||Not working. Using http://support.microsoft.com/kb/914277/en-us, I've tried enable remote connections, stopping, starting the Database engine, still get errors. Disabled remote connections, set the SQL Server Browser to automatic, stopped, started the Database engine, no change. Enable Remote Connections, first Named Pipes, then both TCP/IP and Names Pipes, in conjunction with the SQL Server Browser set to automatic, still get errors. So what do I do?|||*bump*|||So no one really knows how to install the thing? :-(|||

I was having the same issues until I changed the way I was trying to connect:

sqlcmd -S .\SQLEXPRESS.

This was after an install as part of visual studio 2005. I hope this helps.