3

I just did an install of MS SQL SERVER 2019 on Windows 10.

I created a test sql authentication login (login name: test)

When I try to connect from the command line (from either cmd or powershell) the connection fails with the following error message: Password: Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user 'test'..

sqlcmd -U test -P password

--or--

sqlcmd -U test (and fill in the password at the prompt)

If I don't specify login credentials, it uses my windows credentials and the connection works.

What do I need to do to be able to get sqlcmd to login with one of the sql authentication logins I create?

thanks

Improve this question
1

1 Answer 1

Reset to default
3

You need to set the Server Authentication to SQL Server and windows Authentication mode, to do that:

  1. In SSMS Object Explorer right click on Server Node and click properties

  2. In the left pane, click on Security

  3. In the Server Authentication select the SQL Server and windows Authentication mode enter image description here
  4. Click Ok
  5. In SSMS Object Explorer right click on Server Node and click stop
  6. In SSMS Object Explorer right click on Server Node and click start
  7. Run the command again and it will work.
Improve this answer
2
  • That did it. Thanks.
    – jbww
    Commented Mar 13, 2020 at 20:38
  • @jbwwYour wellcome, glad it helped :)
    – gwt
    Commented Mar 14, 2020 at 6:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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