15

I want to run a .sql batch script to delete records from a number of tables from cmd window. So, for that I am trying to connect to my local instance of SQLEXPRESS using following command-

sqlcmd -e -s \SQLEXPRESS

However, I am not able to connect and getting following error:

'Named Pipes Provider: Could not open a connection to SQL Server [2]'.

One more weird thing that I notice from the error message is that above command is trying to connect to SQL Server 2005 whereas the instance running on my machine is SQLEXPRESS 2008.

Can anyone please guide.

P.S. I am using Windows Authentication to connect to SQLEXPRESS which is when I go to connect using Mgmt Studio.

inutan
  • 10,558
  • 27
  • 84
  • 126

2 Answers2

37

Sorry about the late response (just came across your question when searching for something unrelated), but it looks to me like you're just using the wrong case on your arguments:

sqlcmd -E -S .\SQLEXPRESS

-S means "server", whereas -s means "colseparator" (and similarly, lowercase e means echo rather than integrated auth)

Tao
  • 13,457
  • 7
  • 65
  • 76
11

Isn't it possible that the '.' is missing from your command?

sqlcmd -e -S .\SQLEXPRESS

EDIT:

Visit this page. There you fill find some instructions to get connected to your server. First check the Hresult error code in your error message.

I also tried it myself, because I could emulate your problem. I had to do the steps below in order to connect with sqlcmld

  1. Go to All programs\Microsoft SQL Server\Configuration Tools\SQL Server Surface Area Configuration
  2. In Services and connections select SQLEXPRESS\Database Engine\Remote connections
  3. Check Local and remote connections and Using both TCP/IP and named pipes. Click OK.
  4. Restart your database service.

  5. Try to connect to the server:

    sqlcmd -Snp:\\.\pipe\MSSQL$SQLEXPRESS\sql\query
luviktor
  • 2,240
  • 2
  • 22
  • 23