Lost SA Password for SQL 2008 R2
Posted on 24 May 2012
Couldn’t get logged into a lab SQL database using SQL management studio. This box had been cloned and I didn’t know the SA password. The local admin no longer could log in and I later found out this was because the SQL login was in the form of OLDSERVER\administrator, but choosing Windows Authentication on the MGMT studio tried to use NEWSERVER\administrator.