Hello, 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?

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. Thanks, 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.

How to unlock FBA user account

Accepted answer

Echo Du_MSFT 17,141 Reputation points

2021-06-24T10:43:32.787+00:00

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.

Thanks,
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.
Please sign in to rate this answer.
MDuBose 716 Reputation points

2021-06-24T12:32:17.343+00:00

Is there no way to unlock it in the SharePoint website? Updating the database doesn't seem ideal because I would have to involve the DBA. Is there any negative impact with just deleting the account then recreating it?

Echo Du_MSFT 17,141 Reputation points

2021-06-25T10:01:15.997+00:00

Hi @MDuBose ,

According to my research, unlock user through SQL Server is currently the best solution.

Have a nice day!

Thanks,
Echo Du

MDuBose 716 Reputation points

2021-06-25T13:41:41.587+00:00

Thanks @Echo Du_MSFT ,

What is the default max password attempts before a user is locked out?

Echo Du_MSFT 17,141 Reputation points

2021-06-28T09:30:21+00:00

Hi @MDuBose ,

Thanks for your reply.

The default is 5 .

Navigate to “C:\Windows\Microsoft.Net\Framework64\v4.0.30319\Config” and open “machine.config”.

In the <membership><providers> section：

maxInvalidPasswordAttempts：The number of times in a row that a user can enter an invalid password, within the passwordAttemptWindow, before the user’s account is locked out. Defaults to 5.

Thanks,
Echo Du
Sign in to comment

Share via

How to unlock FBA user account

0 additional answers