I am running DNN 9 on one of my test sites and got a locked out user.   I went into the user management and found the user (A superuser), and went to unlock the user.    There is no option now to unlock the locked user account.    Unless I am missing something.  Can someone enlighten me on how I am supposed to unlock a locked out user in DNN 9??

Chaitanya Marvici,

When you go to "Manage" >> "Users", you find three dots at the very right side of the row. Clicking there opens a menu with the option "Authorize User" or "Un-Authorize User" (depending on the user's state in this portal).

If you can't find that, you can do it in SQL ("Settings" >> "SQL Console"):

UPDATE {databaseOwner}{objectQualifier}UserPortals
SET Authorised = 1
WHERE UserID = (SELECT UserID FROM {databaseOwner}{objectQualifier}Users WHERE UserName = '[USERNAME_HERE]')
   AND PortalId = [PORTAL_ID_HERE]

Don't forget to clear cache or restart the application pool after this statement. And these are the tools I did not find in the new Persona Bar, so you can do it by changing the web.config file ("Settings" >> "Config Manager") by adding an empty or a comment line somewhere and save the changes, then change it back to the original and save it.)

Happy DNNing!
Michael

---

Chaitanya Marvici,

you are right, sorry for the misunderstanding. The IsLockedOut property can be found in the aspnet_Membership table, so it can be changed there.

Happy DNNing!
Michael

---