1

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

enter image description here

enter image description here

enter image description here

enter image description here

enter image description here

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

enter image description here

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

enter image description here

Mohammad Reza Shahrestani
  • 1,119
  • 3
  • 17
  • 28
asmgx
  • 7,328
  • 15
  • 82
  • 143
  • 1
    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. https://www.top-password.com/blog/difference-between-sql-server-logins-and-database-users/ Might be worth a read – Caius Jard Jul 21 '19 at 06:30
  • I just want a user that has a login – asmgx Jul 21 '19 at 06:31
  • 1
    What I'm saying is you'll probably have to create both – Caius Jard Jul 21 '19 at 06:32
  • There is new Login and Credentials – asmgx Jul 21 '19 at 06:33
  • 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 Jul 21 '19 at 07:22
  • @ManosAnastasiadis I did that, still the same problem – asmgx Jul 21 '19 at 07:23

1 Answers1

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.

Manos Anastasiadis
  • 116
  • 1
  • 6