How to recover SA password on Microsoft SQL Server 2008 R2|| Forgot Password For Sql Server Recovery
HTML-код
- Опубликовано: 13 май 2014
- When you are using MS SQL Server in mixed mode, it is very important that you know your SA password.
There can be different reasons you lost the password
Person who installed the SQL Server knows the password but has left the building.
You did not write down the password in your password file
Password file is lost
Command to use in cmd prompt:
CREATE LOGIN recovery WITH PASSWORD = 'TopSecret 1′
sp_addsrvrolemember 'recovery', 'sysadmin'
copy paste and press enter ........
Thank you for watching
Thanks for this really helpful video! I just recover one much needed sa password at work when one application team was waiting for this.
This isn't a password recovery, it's a password reset.
If it was recovery you would be getting the existing password.
Thanks for this video. I'm using sql 2012 so one step is slightly different. But this video has been a great help
Thanks for this video, I don´t use the command SQLCMD for create the new user because I gave error, but used the command OSQL ( osql -S NameServer\Instance -E can chance the password the user SA.
Thank You..... Successfully done
in cmd i am getting this error after putting in sqlcmd command
message 18461,level 14,state 1,server HP-PC,line one
login failed for user HP-PC\HP
You should be part of windows admin group
This doesn't seem to work. There is a much simpler way to reset the sa password:
Using SQLCMD, issue this command:
sp_password @new = ’newpassword’, @loginame = ‘sa’
Type "go" to execute the command
Type 'exit' to exit SQLCMD
This will reset the password to whatever you set for 'newpassword'
It worked. Thank you..
Thanks guy, help very
Do it but for iPhone can you
Thanks you 🎉
*** CLICK BAIT! *** This is password reset, not password recovery.
thank you
thanks that did it!
if i want to reset database username and password can?
Hw
sql 2012 i am unable to log in
Doesn't work
In such situation you can take the help of third party SQL password recovery software www.sqlrecoverysoftware.net/sql-server-password-reset/