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