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