Hello Team,
I need to add new user AD to sharepoint 2013 with SQL , not with powersell.
how to do this ? i don't find a good requête SQL to perform this action
many thanks for help
Gone
Hello Team,
I need to add new user AD to sharepoint 2013 with SQL , not with powersell.
how to do this ? i don't find a good requête SQL to perform this action
many thanks for help
Gone
Hi @Gone-9731
Per my knowledge, we could not add AD user with SQL.
Could you tell me the reason why you want to create a new user AD to SharePoint 2013 with SQL?
SharePoint standard installation uses as default AD to query the Domain Controller and to check user credentials through Windows Authentication. FBA uses a custom database created separately from AD to store user credentials. Authentication using FBA is executed by a SQL DB query. When FBA is used to extend SharePoint sites, external users (not AD users) have access to SharePoint.
If this is not feasible for you, please feel free to reply.
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.
Hi @YiLu-MSFT
Thanks for your help;
i provide below more détails about this issue :
1- we have 02 domaines AD : dev and prod
2- sharepoint is configured on domain DEV : we can add user from AD DEV
3- we have some users from AD prod is already added to sharepoint and can connect
4- since 01 month we cannot add new user from AD prod to sharepoint
5-Admin domaine confirm that we can add user from AD PROD to sharepoint using account AD prod and not dev, but we cannot do this with account dev or prod
6- in log file no détails can help to resolve this issue
So for this reasons i would like to add users with SQL to sharepoint
Many thanks
Hi @Gone-9731
The users added in SQL is identified with Form based Authentication (FBA), so we could not add AD users to SQL.
8 people are following this question.