How to unlock FBA user account

MDuBose 716 Reputation points


In SharePoint 2016, I've created an FBA user account. I've tried to reset the password but got an error that the account is locked. I've noticed on the "Manage Forms Based Authentication Users" page that this account is locked. How can I unlock this account?

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,273 questions
0 comments No comments
{count} votes

Accepted answer
  1. Echo Du_MSFT 17,126 Reputation points

    Hello @MDuBose ,

    In SQL FBA DB, in the asp_membership table that has an IsLockedOut column(boolean type). You need to set the column value to false. Then the user will be unlocked.

    Echo Du


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 additional answers

Sort by: Most helpful