Resetting the Sitecore admin password

When you first install Sitecore, the standard account is created with a username of “sitecore/admin” and a password of “b”.  You should immediately change that password, especially if you are working on a production instance of Sitecore.  If you somehow forget the password, you can update the database to restore the password back to “b”.

Sitecore uses the Microsoft .NET Membership model in the Core database.  The password is stored in a one way salted-hash.  There is no way to decrypt the current password.  When a user enters their password in Sitecore, it is passed through the hashing algorithm and the result is compared against the value in the database.  Therefore, the only solution is to run a sql query to set the salt and the hashed password in the database so that “b” will be authenticated as a password.

First, open SQL Server Management Studio and connect to the appropriate database server. Find the core database, right click and choose “New Query”. Execute the following query:


update [aspnet_Membership] 
set password='qOvF8m8F2IcWMvfOBjJYHmfLABc=', passwordsalt ='OM5gu45RQuJ76itRvkSPFw==' 
where userid in (select userid from [aspnet_Users] where username = 'sitecore\Admin')

Author: Dan Persson

As the VP of Technology, Dan leads the MedTouch Product Team and is responsible for our healthcare modules for Sitecore as well as serving as a technical consultant to key clients. Dan has 15 years of experience with a variety of Content Management Software (CMS) tools and was instrumental in building the MedTouch Healthcare Accelerator Framework. He served as Technical Lead on several MedTouch award-winning sites, including The University of Kansas Hospital (Sitecore Healthcare Site of the Year Winner), Drexel Medicine (Interactive Media Awards, Hospital Best in Class 2012) and Providence Health & Services. Dan is a long-standing Sitecore certified developer and graduated from the University of Massachusetts, Amherst, with a B.S. in Computer Science.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s