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

  • 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?

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

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

  • Hi,

    can you show us the errorlog, when the error occours.

    And, is it possible, that someone tries to login with the wrong credentials?

    Kind regards,

    Andreas

  • Capture failed logins using extended events !

    This may get you started: "Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events" as it gives you more details.

     

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • ok problem solved, thank you for the response

  • aman wrote:

    ok problem solved, thank you for the response

    In the interest of helping others who visit the site facing the same problem, just provide a short description of how you resolved the issue

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply