Some quick SQL tips for myself
osql -E- Login with your Windows credential
to change your authentication mode to Mixed Mode (meaning you can use both local password such as sa, and Windows Credentials), change…
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\LoginMode from 1 (default) to 2(mixed).
Now that you have mixed, mode you can change the sa password..
osql -E
sp_password NULL,”<new-password>”,sa
go