Thursday, April 6, 2017

Change SQL Server Password if forget


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.

No comments:

Post a Comment