sqlcmd error

[Icon Iconoclast]

Each time I try to run sqlcmd, this is the error message I get:

HResult 0*2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0: A network related
or instance-specific error has occurred while established a connection to
SQL Server. Server is not found or not accessible. Check if instance name is
correct and if SQL Server is configured to allow remote connections. For
more information see SQL Server Books Online.
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout
expired.


I'm using SQL Server 2008 Express Edition. I can use user instances without
any problem. Why am I getting the above error? What's the remedy?

 

[Gregory A. Beamer]

One thing that often solves the problem is turning on SQL Browser. Without
this, it will not allow remote connections.

--
Gregory A. Beamer
MVP: MCP: +I, SE, SD, DBA

Blog:
http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think Outside the Box! |
********************************************