2

I've setup the instance SQLEXPRESS via SQL Server 2008 R2 installation, added a security login with all server roles, one called 'sqluser'.

The server authentication is SQL Server and Windows Authentication mode. However, when i specify the -S property, login fails.

There is no firewall enabled and SQL server even accepts connections from remote hosts.

C:\Users\user>sqlcmd -U sqluser -P qwerty -Q "Select * FROM testdb.dbo.testtable"

Output:

integer
-------
      1
      2
      3
      4

(4 rows affected)

However when specifying 'localhost' the query fails... Question is Why?

C:\Users\user>sqlcmd -S localhost/sqlexpress -U cpt -P 1234 -Q "Select * FROM cpt.dbo.testme"

Output:

HResult 0x43, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [67].
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or in    stance-specific error .....
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.

Changing 'localhost' with '%COMPUTERNAME' is same result if someone would be wondering. The server is running as a LocalSystem instance.

1 Answer 1

3

You need to specify the -S switch to provide the instance name for sqlcmd to connect to, and it should be in the format "localhost\sqlexpress" instead of "localhost/sqlexpress".

2
  • got it, thx - actually finally found out last night :)
    – mschr
    Nov 12, 2012 at 15:41
  • You can use -S .\sqlexpress as a shorthand for localhost
    – icc97
    Dec 28, 2017 at 8:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.