Question

How to reset the sa password in sql server 2008 r2?

Answer 1

hai




SA user (abbreviation for "System Administrator") is the administrative login for MS SQL Server. What do you do if you forgot SQL Server SA password ? Reinstall MS SQL Server or just drop everything and walk out of here? For whatever reason, if you forgot your SQL Server SA password and the windows account told you don’t have the permissions to change it, this article will demonstrate several options for resetting your SQL SA password.

These steps work for SQL Server 2005, 2008, 2012 and later.



I hope it's help you