IIS Server Error cannot execute the command while adding new Role Provider - Sharepoint 2019

[Robin456]

Hi,

I have installed the Windows Server 2022 with SharePoint Server 2019, I have created one web application and trying to configure the Form-Based Authentication from the IIS  Manager, whenever I am trying to add the new Role Provider below error occurs every time

Its only happening for SharePoint web application

Thanks in advance

[#2]

Hi 

I am also getting the same error. Please help if any solution for this.

Configuring form based authentication in SharePoint 2019 on windows server 2022. I am getting this error while adding providers in the IIS for SharePoint site.

thank you

[#3]

Finally I have done it via web.config

Added the below code in In the <roleManager><providers> section 

<add name="FBARoleProvider" connectionStringName="FBADB" applicationName="/"
 type="System.Web.Security.SqlRoleProvider, System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

FBADB = your connectionStringName

Thanks,

Mukesh