• Question – How to restore lost ‘sa’ password for MSSQL?
  • Answer – Start CMD in administrator mode
net stop MSSQLSERVER && net start MSSQLSERVER -m #start in single user mode
sqlcmd
1>ALTER LOGIN sa enable
2>GO
1>CREATE LOGIN NewSA WITH PASSWORD = 'Password@1234';
2>ALTER SERVER ROLE sysadmin ADD MEMBER NewSA
3>GO
net stop MSSQLSERVER && net start MSSQLSERVER #start normally

Then reset the password through the security section