Click 'Connect' select the database to run the script on. Then press 'New Query'.
Paste the query in and press "Execute"
Disclaimer! Messing around with scripts and direct db access can kill your Umbraco project, so be careful and if you can BACK UP the database first (Right click database, Tasks > Back Up.
Password problem . .
Hello there -
I have a small problem.
i recently just got back into contact with someone that once asked me to make a small webpage for them.
it was more or less complete and ready. but the project got put on hold. But now they are interested again.
luckily i have the intire webfolder and content - but alas when i tried to log into umbraco I realised that i no longer remembered the password -.-
The "site" never got published or uploaded and is still only in development.
but i guess i am out of luck ?
Hey Jan,
Depending on which Umbraco version it is (if the password is hashed or not) you can reset the password by following the thread here
http://our.umbraco.org/forum/using/ui-questions/4790-ouch-forgot-admin-password-how-to-reset?p=0
Rich
im using version 4.0.2.1
- but i am alittle sketchy/rusty on the process on running a script on Microsoft Server management.
wouldent wanna mess it up o.o -
i have access to the server umbracocms and all that. but where/how do i run that script ?
pardon the newbieness from me :P
Hey,
You would need to get access to the database I'm afraid.
Rich
Oh i have access to it -
ITs just i am not sure how to run that script on the link you showed me
Do you have SQL Server Management Studio installed anywhere?
yes - and i have been looking through it - but am unsure how to run scripts -
Click 'Connect' select the database to run the script on. Then press 'New Query'.
Paste the query in and press "Execute"
Disclaimer! Messing around with scripts and direct db access can kill your Umbraco project, so be careful and if you can BACK UP the database first (Right click database, Tasks > Back Up.
Rich
Note! If your password isn't hashed (depends on what version your running and the settings)
Run this script first and see if you can see the password
Thanx a bunch Rich I got it working, Hope my noobness did not hurt your head to much ;)
But got it working by changing the web.config password from hashed to clear and then changed the password to default
Awesome now i can get back to work where i left off from ;)
no problem, glad you got it working :)
is working on a reply...