sql server connect: You will have to enabled remote connections on the server. See the
screencast section on my site for more information.


HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Make sure SQL Browser is running. if you use SQL Server Express you
will have to use the instance name of SQL Server express instead of
pointing to the default instance:

SQLCMD -S Servername\SQLEXPRESS

if you cannot or don=B4t want to start the Browser service you will have
to name the port number after the server name:

Servername,portnumber (Port Numbers are assigned dynamically by
default for SQL Server so you should either change to a static one or
use SQL Server Browser)

-Jens.

Hi,

i have installed sqlserver express 2005. I can manage sqlserver with MS sql
server Sudio express. I also can use .mdf files with asp.net application.

But when i type 'sqlcmd' in a dos-windows, i get the error:
"Named pipes provider: could not open a connection to sql server"

I also tried with: sqlcmd -S myserver (same error).

Thanks for help
Michel

Hi Jens,

i did what you told me and i also checked in "Management Studio express"
that property 'connection' is set on: allowed.
But i still get the same error.


"Jens" <Jens@sqlserver2005.de> schreef in bericht
news:1172077068.100881.195070@s48g2000cws.googlegroups.com...
[quoted text, click to view]

Thanks, it works now

"Jens" <Jens@sqlserver2005.de> schreef in bericht
news:1172080893.735301.137360@v33g2000cwv.googlegroups.com...
Make sure SQL Browser is running. if you use SQL Server Express you
will have to use the instance name of SQL Server express instead of
pointing to the default instance:

SQLCMD -S Servername\SQLEXPRESS

if you cannot or don´t want to start the Browser service you will have
to name the port number after the server name:

Servername,portnumber (Port Numbers are assigned dynamically by
default for SQL Server so you should either change to a static one or
use SQL Server Browser)

-Jens.