OK so  I'm sure this is not the first posting about "crap, how do I retrieve the username and password from the database cos I don't know what they are".

I have installed a sort of custom DNN with files and database on a hosting server.  All looks fabulous in terms of the install connectivity to the db and even viewing the site - problem is, the folks that sent me this sort of slightly "custom" (basically DNN just coupe extra modules thrown in) DNN seem to have given me the wrong admin username and password for the site - so I basically have everything working except now I can' t login.  I can obviously see the uname and password in the db but they are encrypted and I don't know what encryption is being used.

Oh wise DNN Gods - anyone know how I can retrieve username and password in this situation?  (Decrypt somehow?)

Dave

I have a blog post on my site http://www.mitchelsellers.com that provides you the scripts needed to complete the steps mentioned by Shawn above!

Glad we could help, don't forget to mark this as being answered.