Sa password missing

  • there is a way to restore a sa password??

    we lost and nobody knows.

  • Try to connect with NT Authentication with someone that is a member fo the local admin group. If you can't get in that way, then... well... you still have a few choices. Are their any other application accounts that have access? If so you can log on with them untill you find one that was mistakenly setup with admin rights. Still not able to get in... two more options: Brute Force and Rebuild Master.

    Good luck,

    Dan

  • Do any of your apps use the sa account?

    If not, and you have an nt account with admin rights (or a local admin account if you leave the builtin/admin with sql rights) you could just change the password.

    As for getting the password you will need to go with Dan's suggestion of a brute force attack (sqlsecurity.com have a script), or if you have an admin account read the previous post on cracking.

    Steven

  • If you can connect with NT, you can snag the passwords and get them. See the "cracking thread" in this forum.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

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

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