asked
My sa password has been locked. I dont have any other credentials with sysadmin privileges. Is there any way to unlock sa password. I have no other credentials to log in to the server
Unlock sa password
This web site runs by votes. For all the helpful answers below, please indicate this by clicking on the thumbs up next to each of those answers. If any one answer lead to a solution, please indicate this by clicking the check mark next to that answer.
Googling for "sa account locked" comes up with several ideas. Have you tried that?
Hi Shambhu,Which SQL Version you are using? In case of SQL Server 2008 or R2, check whether NTAuthority\sytem has sysadmin rights. If yes then you can use PSEXEC Tool. Please refer below Link:
http://blogs.msdn.com/b/sqlserverfaq/archive/2012/12/18/how-to-login-to-sql-server-with-nt-authority-system-using-psexec-tool.aspx.
http://www.mssqltips.com/sqlservertip/2682/recover-access-to-a-sql-server-instance/
If you are a local admin on the box, you can follow this [step by step process](
http://timradney.com/2013/11/21/how-to-reset-the-sa-password-in-sql-server/) that I have used dozens of times to reset the SA password. In my cases it would be when a server has changed domains and our SQL accounts were tied to the old domain which can no longer be authenticated. This process shows you how to start SQL in single user mode, create a new account, make it SysAdmin, then you can connect using that account and correct what ever problems you have, be it resetting SA or what ever you need. Hope this helps you out.
Hi, google fir a program called hashcat, i have used it before to recover a sql server sa password.
20 People are following this question.
