Change SQL Server Password if forget

Hi,

Some time we come in a situation where we forgot our ssms or squeal server password.
Here is way to unlock sa user account or change the password:

1. Login into SQL Server using Windows Authentication.
2. In Object Explorer, open Security folder, open Logins folder under Security->Logins . Right click on sa account and go to Properties.
3. Type new password and confim password.
4. That's done!

Note: If you face issue that password is not changed and having some error then please have a look under Status option and check 'sql server authentication' is unchecked 

I hope you enjoy this Sitecore blog. Stay tuned for more Sitecore related articles.

Till that happy Sitecoring :)

Please leave your comments or share this article if it’s useful for you.