Not able to login to site using FBA on sharepoint 2019

Question

Greetings,

I have configured FBA on sharepoint 2019 on prem..its coming on people picker

Problem: unable to use sql user althiugh i hve given site collection admin permission..

Solution: how can i login to site using fba user

Note: windows users are working fine to login to site onle sql user unable to login to site

Thanks

Answer 1

Hi @qasimidl ,

Per my understanding you could:

1.Check the ULS logs and event viewer logs for more error messages.
2.Go to Central Administration site->Manage web applications->select the relevant web application->click “User Policy” in the ribbon->add the relevant user and grant permission.
3.Give the Sql user local admin permissions.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.