question

TelleCestic-8280 avatar image
0 Votes"
TelleCestic-8280 asked TelleCestic-8280 answered

Create DB User

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 attachment113955-errorcode.png


sql-server-generalsql-server-analysis-services
errorcode.png (233.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TelleCestic-8280 avatar image
0 Votes"
TelleCestic-8280 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.