myITforum and Windows IT Pro Forums

 SQL Server SA Account Is Locked Out

Author Message
shawna

  • 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 10:00 PM (permalink)
0
Hello
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!
 
#1
    gjones

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

      Jump to:

      Current active users

      There are 0 members and 3 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-2014 ASPPlayground.NET Forum Version 3.9