Login failed for user sa sql server 2022 - windows server 2022

• aman

  SSC Enthusiast

  Points: 180

  More actions

  June 24, 2024 at 7:45 am

  #4430982

  i got the login failed error for user sa, but not always

  so I went to server properties - security - server authentication

  change to windows authentication mode

  and change again to sql server and windows authentication mode, and restart sql server. this happened when i upgraded to sql 2022,

  I have Service Pack 13 installed, can anyone help?

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  June 25, 2024 at 8:10 am

  #4431261

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• andreas.kreuzberg

  SSCertifiable

  Points: 6191

  More actions

  June 25, 2024 at 11:49 am

  #4431297

  Hi,

  this post is duplicated.

  Please reply on this post:

   

  https://www.sqlservercentral.com/forums/topic/login-failed-for-user-sa-sql-server-2022-windows-server-2022

• June 25, 2024 at 3:57 pm

  This was removed by the editor as SPAM