[Question] How to reset SQL Password?

[kingmoka]

as thread title says .. i forgot my sql 2012 pw and i don't want to re-install it ..
anyone knows a simple way to reset sql pw please share it

[[NoReason]]

Google maybe?

[鳳凰城]

1. Download on your local PC, install and launch it.
   
2. Click the Open File button. Select the SQL Server master database file (master.mdf). Typically it is located in the folder: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.
   
3. The program will automatically decrypt the master database file and display all user accounts in your SQL Server. Select the SA account, click the Change Password button. Type a new password and click OK.
   
4. The program will replace the existing password with your new password, and also unlock your SA account if it's already locked out or disabled.

[KingDollar]

go to cmd
and following the next steps
1.osql -S YourSqlName\SQLEXPRESS -E
2.sp_password NULL, 'insert_new_password_here', 'sa'
3.go

#done
thank me later lel

[Trinity^]

or you can just login with your windows account...

[Syloxx]

the easiest way is...

login with Windows Authentication

and run this query:

ALTER LOGIN [LOGIN_NAME] WITH PASSWORD = ’NewPassword’