question

DuboseMicheleADIT-6155 avatar image
0 Votes"
DuboseMicheleADIT-6155 asked EchoDu-MSFT commented

How to unlock FBA user account

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?

office-sharepoint-server-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

EchoDu-MSFT avatar image
0 Votes"
EchoDu-MSFT answered EchoDu-MSFT commented

Hello @dubosemicheleadit-6155 ,

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.




· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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?

0 Votes 0 ·
EchoDu-MSFT avatar image EchoDu-MSFT DuboseMicheleADIT-6155 ·

Hi @dubosemicheleadit-6155 ,

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

Have a nice day!

Thanks,
Echo Du

0 Votes 0 ·

Thanks @EchoDu-MSFT,

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

0 Votes 0 ·
Show more comments