Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. SQL Server
  3. Question
SQL Server

What to do if login failed for user sa?

Asked by Andrew Jenkins Oct 4, 2022 1.6K views 1 answer
Share

About this question

 I can access my databases through SQL Server Management Studio (SSMS) by using my Windows account no problem.

I have two issues though: I want to enable sa and then try to log in using sa and the password. I get this error:

I enabled the SQL Server authentication

I tried to create a new user, but that user cannot connect either:

How can I fix this? 

Your answer

1 Answer

More SQL Server discussions

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Latest SQL Server Blogs

Guides, tips and career advice on SQL Server from JanBask experts.