How to unlock FBA user account

Question

How to unlock FBA user account

MDuBose 706

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?

Answer 1

Echo Du_MSFT 16,911

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.

MDuBose 706 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 16,911 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 706 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 16,911 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

How to unlock FBA user account

0 additional answers

Activity