Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    Kingston, Ontario
    Posts
    106

    Red face Unanswered: User 'sa' is locked out

    I just brought SQL Server 2005 up on Windows Server 2003 a few days ago. Everything was going great up until a few minutes ago. I tried to connect using the Management Console and get the message

    Login failed for user 'sa' because the account is currently locked out. Your administrator can unlock it.

    It's the administrator that's locked out!

    Do I have to reinstall SQL Server all over again?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Nope. You should be able to log into the SQL box with a Windows Administrator account, connect to SQL Server with a trusted connection, and unlock SA from there.

  3. #3
    Join Date
    Aug 2003
    Location
    Kingston, Ontario
    Posts
    106

    Talking

    Quote Originally Posted by MCrowley
    Nope. You should be able to log into the SQL box with a Windows Administrator account, connect to SQL Server with a trusted connection, and unlock SA from there.
    Perfect! Thanks a bunch!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •