How to recover SA password on Microsoft SQL Server 2008 R2|| Forgot Password For Sql Server Recover

Описание

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