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.
Found a great article on how to reset the local SA account on Gert Van Gorp’s blog. Worked perfectly. Thanks to Gert!
No responses yet. You could be the first!
Leave a Response
