Error 15151

  1. Open SQL Server Configuration Manager.
  2. Double click SQL Server Services.
  3. Right Click SQL Server and select Stop.
  4. Right Click SQL Server and select Properties.
  5. Select Advanced.
  6. Add -m; in front the Startup Parameters.
  7. Right Click SQL Server and select Start.
  8. Open cmd.
  9. Type sqlcmd.
  10. Type CREATE LOGIN recovery WITH PASSWORD = 'password'.
  11. Type sp_addsrvrolemember 'recovery', 'sysadmin'.
  12. Right Click SQL Server and select Stop.
  13. Right Click SQL Server and select Properties.
  14. Select Advanced.
  15. Remove -m; in front the Startup Parameters.
  16. Right Click SQL Server and select Start.
  17. Login your database via Windows Authentication.
  18. Go To Security > Logins > sa.
  19. Insert the new password in password column and confirm password column.
  20. Make sure enforce password policy checked.
  21. Restart database.