When you forget SQL server password

When you don’t remember MSFT SQL server’s sa’s password, here is how to reset it without uninstall/installing it.

Visual Studio Installer installed SQLExpress onto my box, but I was not in sa. Here is how to run SQL serer (or express) in console mode and add yourself into sa.

sqlservr.exe -m -c -sSQLExpress
sqlcmd.exe -S.\SQLEXPRESS -E
sp_addsrvrolemember @loginame=[yourdomain\yourid], @rolename='sysadmin'