Problem for creating new user in SQL Server Express

Question

I have SQL Server Express on Windows 10 Pro:

It works fine.I created databases using the default user (Windows user). I need to specify a user ID and password for other purposes.

I did this

but when I try to login using this user id and password, I get this error

I thought it is very easy to add new user. It seems harder than I thought

I also tried to use SA user ID,

I enabled it

and changed the password

Yet I still get this error

Do you fully understand the difference between a user and a login? I ask because your question text says you're creating a new user but your screenshots show you're creating a new login and they're not the same thing - login has the password but a login's associated user grants permissions to databases. top-password.com/blog/… Might be worth a read — Caius Jard
– Caius Jard, Commented Jul 21, 2019 at 6:30
Users have been created in each db, since the login is mapped in User Mapping tab. However, it is strongly recommended to only map the login to the dbs you actually need to access, using the absolutely necessary roles. — Manos Anastasiadis
– Manos Anastasiadis, Commented Jul 21, 2019 at 7:22

Manos Anastasiadis · Accepted Answer · 2019-07-21 07:24:13Z

2

It looks like you might have not enabled SQL Server Authentication too in your server during installation. Setup defaults to Windows Authentication only. See also Login to Microsoft SQL Server Error: 18456.

answered Jul 21, 2019 at 7:24

Manos Anastasiadis

1161 silver badge6 bronze badges

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

Collectives™ on Stack Overflow

Problem for creating new user in SQL Server Express

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related