Create DB User

Question

Hi all,

I am a complete beginner when it comes to Databases.
I have created a Database, new Database Table and a new User.
Somehow, I cannot login with this new user using the "SQL Server Authentication" login method.

Right now I'm using the built in Windows account to connect to my SQL Server.
Does anyone know if I am forgetting something? The youtube tutorial shows it exactly like I did it, but I just cannot login.

Thank you,
Telle

I keep getting this error code in the attachment

Answer 1

Try enabling Mix authentication mode if it is disabled

https://community.bmc.com/s/article/Enable-mixed-mode-authentication-for-SQL-Server

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

Answer 2

Thanks a lot. Been trying around for 1 hour just because of one checkbox.