Sql server authentication fails using sqlcmd

Question

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

Just to be sure - you did change the Server Authentication Mode to allow both Windows and SQL authentication? — Filburt
– Filburt, Commented Mar 9, 2020 at 17:25

gwt · Accepted Answer · 2020-03-09 17:26:08Z

3

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

In SSMS Object Explorer right click on Server Node and click properties
In the left pane, click on Security
In the Server Authentication select the SQL Server and windows Authentication mode
Click Ok
In SSMS Object Explorer right click on Server Node and click stop
In SSMS Object Explorer right click on Server Node and click start
Run the command again and it will work.

answered Mar 9, 2020 at 17:26

gwt

2,4334 gold badges40 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

jbww Over a year ago

That did it. Thanks.

gwt Over a year ago

@jbwwYour wellcome, glad it helped :)

Collectives™ on Stack Overflow

Sql server authentication fails using sqlcmd

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related