Ouch - Forgot admin password on Umbraco 7.0.4 installation

It was one of those days...Typed in the password and swore I'd remember it! But it got a typo in it and this post saved me... To reset the admin password of a Umbraco website. In SQL server, run the following script on the database: USE INSERT-Y...