Umbraco - Reset the Admin Password via SQL Server

To reset the admin password of a Umbraco website.

1. In Sql server, run the following script on the database:


USE  INSERT-YOUR-DATABASE-NAME-HERE
GO

UPDATE umbracoUser set userdisabled=0, userLogin='admin', userPassword='default' where id=0

2. In your web config file, find the "UsersMemnershipProvider" section, change the setting:


passwordFormat="Hashed"
to
passwordFormat="Clear"


You should now be able to login using the Username: Admin and the Password: default ("the two sweetest words in the english language").

Comments

  1. Thanks! I followed same procedure, but used SQL Server Compact Toolbox (SQL CE) to edit userPassword directly before updating web.config. It worked!

    ReplyDelete
  2. Thanks Mark..You saved my day...

    ReplyDelete
  3. dont see where to run the sql syntax on umbraco user interface

    ReplyDelete

Post a Comment

Popular posts from this blog

Umbraco 7 - C# Razor - Passing a parameter variable from a Template to a Partial View.

Umbraco Razor Sort Nodes Ascending or Descending