How To Recover The SA Password On SQL Server 2008 R2

If you’ve lost the SA password of your SQL Server 2008 R2 computer, don’t panic; it can be recovered! To recover a lost SA password on SQL Server 2008 R2, do the following: Start SQL Server Configuration Manager Stop the SQL Server services Right click the SQL Server (<<Instance name of SA password to recover>>) […]
Continue reading…

 

How To Recover The SA Password On SQL Server 2005

If you’ve lost the SA password of your SQL Server 2005 instance, you can recover the password with this command. To recover an SA password on a SQL Server 2005 server, do the following: Open a command prompt on the SQL server Type: OSQL -S SQLServerName -E Hit enter Type: EXEC sp_password NULL, ‘Password’, ‘sa’ […]
Continue reading…