Login Failed for user sa

Hello, I have a problem connecting to the database. I get an error.

But if delete a user name “sa” that turns a normal connection.

But if I connect to the database through another terminal then this trick no longer works, and writes an error:
Login failed for user ‘Guest’

So it says “password for sa user is incorrect”. You need to know password for sa user to be able to connect from terminals. You’ve set password for sa user while setting up sql server. If you didn’t do so check step-3 and step-4 on this documentation.


Looks like your using Windows authentication for SQL server. Use MSSMS and change it to mixed mode then enable the sa user and set a password.

Bah Emre your too fast today :smile: