Since you have access to the database, it will be relatively easy to change the email address so that the "Forgot Password" function can be used or reset the user account's password.

As the email will need to be changed anyway, lets try that approach . . .

1. Open the database table XXX.YYYUsers where XXX represents the value of the databaseOwner specified in the site's web.config and YYY represents the value of the objectQualifier also specified in the site's web config. Most often the databaseOwner will be "dbo" and the objectQualifier either blank or "dnn_". For example with "dbo" as the databaseOwner and blank for the objectQualifier, the table name will be dbo.Users.

2. Locate the friend's username in this table. The standard DotNetNuke installation will create two users "admin" and "host". Quite possibly, both accounts were originally set up with the friends old email address and if no other users registered should be the only two accounts in the table.

3. In the rows corresponding to the desired username(s),  change the value in the column "Email" to the new email address. I am not familiar with GoDaddy's Web Server Admin tool but if it works like myLittleAdmin used by some hosts, you can change a value and save the change by simply typing over the old value then clicking anywhere in another row of the table.

4. Make a note of the username(s) for which you changed the email address.

5. Open the table XXX.aspnet_Users and locate the row(s) having the same username(s) in the UserName column.

6. Make a note of the long string of numbers and letters (GUID) in UserID column of the corresponding row(s). You will not be making any changes to the aspnet_Users table.

7. Open the table XXX.aspnet_Membership and locate the row(s) have the same values in the UserID column that you noted in #6 above.

8. In each corresponding row, change the values of the column Email from the old to the new email address.

9. If there is a column named LoweredEmail in the table change the value from the old to the new email address but all in lower case letters.

10. Close the Web Server Admin tool.

11. Visit the website and for each of the account usernames that had there email address updated use of the "Forgot Password" function to email the passwords to the new email address.

If for some reason the password can not be sent or received, let me know and I'll go through the proceedure for changing the password in the database - a bit more complicated, though.

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner