Share via

SQL sa user not working

Jonathan Brotto 1,076 Reputation points
2021-03-22T17:03:54.157+00:00

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]: /api/attachments/80306-sa-login.png?platform=QnA [2]: /api/attachments/80307-sa-user.png?platform=QnA

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments No comments

Answer accepted by question author

TheDBLearningGuy 171 Reputation points
2021-03-22T18:48:49.707+00:00

Hi @Jonathan Brotto ,

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

Was this answer helpful?

0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.