For security reason, we need to change SA password in SQL Server. Today we are going to discuss how to change SA password in SQL 2008.
Method 1: Changing SA password in SQL 2008 by using Management Studio
Step1: Login into SQL Server 2008 with Windows Authentication mode. (This means you have to login in the local Windows computer of SQL Server 2008.)
Step2: Now go to “Object Explorer>>Security>>Logins”. Next find sa and right click on it.
Step3: Select “Properties”. And then in the newly pop-up window, enter a new password to the Password filed, and confirm password later.
However, what if we failed to change SA password SQL Express 2008 with method 1? And what if we forgot or lost SA password already? Then under that circumstance, how should we do? Well, please follow the steps mentioned below to change SQL2008 password for SA account.
Method 2: Change SA password with SQL Password Recovery
Step1: Download and install SQL Password Recovery on your computer.
Step2: Run SQL Password Recovery and next click on “Open” to import the target .mdf file.
Step3: All the user accounts of the SQL Server will be displayed. Now select SA account and then click “Change Password” button.
Step4:Type a new password and then confirm it in the newly pop-up “Change Password” window. Until here, everything is done! Now just click “OK” to end and exit.
Well, you have changed a forgotten or lost SQL SA password into a new one and now you can login SQL Database with this new password.
Additionally, if you are interested in these methods to change SQL Server 2008 password, then you can visit here: http://www.recoverlostpassword.com/products/sqlpasswordrecovery.html for more information such as free download site for SQL Password Recovery, video tutorial guide for how to reset SA password with SQL Password Recovery etc. However, you also do not have to follow the instructions described in this article if you thing they are not for you.