question

JonathanBrotto-3536 avatar image
0 Votes"
JonathanBrotto-3536 asked TheDBLearningGuy answered

SQL sa user not working

I can log into my SQL server engine with windows authentication, but not with SQL server authentication and the sa user. I made a password but it seems to be greyed out. ![80306-sa-login.png][1] ![80307-sa-user.png][2] [1]: /answers/storage/attachments/80306-sa-login.png [2]: /answers/storage/attachments/80307-sa-user.png

sql-server-general
sa-login.png (31.1 KiB)
sa-user.png (23.9 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.

1 Answer

TheDBLearningGuy avatar image
0 Votes"
TheDBLearningGuy answered

Hi @JonathanBrotto-3536,

Did you get any error while you tried connecting through SQL authentication mode.

What is the server authentication configured for the SQL Server instance?

This can checked through SSMS
Connect to the instance --> Right click on the instance --> Properties --> Security --> Server authentication

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.