Post reply

sa login locked

  • November 21, 2011 at 8:58 am

    #246638

    how to unlock sa login?

    because i m sql user and dont have sa admin rights , so when i ran the command in newquery window..

    ALTER LOGIN sa WITH PASSWORD = 'test@123' UNLOCK

    It showing error, this login dont have proper admin privilages?

    so how to resolve proble,,?

    Anyone help me ?

    Thanks

    jeri

  • November 21, 2011 at 9:00 am

    #1410794

    Login with any other system admin login or windows account and run the code.

  • November 21, 2011 at 9:02 am

    #1410799

    we dont have even single admin login.. what to do?

  • November 21, 2011 at 9:04 am

    #1410801

    Local admin on the machine can login SA.

    Plenty of details on google about that problem.

  • November 21, 2011 at 9:17 am

    #1410818

    You must have a admin login somewhere, like a windows authentication one...

    Members of local admin might be automatically sysadmin, depends on the patch level and the OS.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 5 posts - 1 through 4 (of 4 total)

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