myITforum and Windows IT Pro Forums

 SQL Server SA Account Is Locked Out

Author Message

  • Total Posts : 1
  • Scores: 0
  • Reward points : 100
  • Joined: 7/21/2014
  • Status: offline
SQL Server SA Account Is Locked Out Monday, July 21, 2014 11:00 PM (permalink)
I just tried to connect to SQL Server with SQL Server Authentication mode, but found I have forgotten the SA password so that I was stuck at the error message saying "Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it". I am a new SQL Server user. Now how can I unlock my locked SA account? Anyone can help me? Thanks in advance!

    • Total Posts : 2808
    • Scores: 146
    • Reward points : 238630
    • Joined: 6/5/2001
    • Location: Ottawa, Ontario, Canada
    • Status: offline
    Re:SQL Server SA Account Is Locked Out Tuesday, July 22, 2014 10:01 AM (permalink)
    By default the SA account is not enabled. You need to use a AD account to access the server, which has SA permission.
      Online Bookmarks Sharing: Share/Bookmark

      Jump to:

      Current active users

      There are 0 members and 1 guests.

      Icon Legend and Permission

      • New Messages
      • No New Messages
      • Hot Topic w/ New Messages
      • Hot Topic w/o New Messages
      • Locked w/ New Messages
      • Locked w/o New Messages
      • Read Message
      • Post New Thread
      • Reply to message
      • Post New Poll
      • Submit Vote
      • Post reward post
      • Delete my own posts
      • Delete my own threads
      • Rate post

      2000-2018 ASPPlayground.NET Forum Version 3.9