How to recover SA password on Microsoft SQL Server 2008 R2

http://v-consult.be/2011/05/26/recover-sa-password-microsoft-sql-server-2008-r2/ create a new user. Enter following commands CREATE LOGIN recovery WITH PASSWORD = ‘TopSecret 1′ Go grant the user a SYSADMIN roles using the same SQLCMD window. sp_addsrvrolemember ‘recovery’, ‘sysadmin’ go

SQL Error 924 Database Single User mode change to Multi Users mode

exec sp_lock --- find the spid by dbid with lockType X Kill spid ----- kill the Spid exec sp_who --- find the Spid Kill spid ----- kill the Spid again ALTER DATABASE EmailXtender Set MULTI_USER