question

Gone-9731 avatar image
0 Votes"
Gone-9731 asked YiLu-MSFT commented

Add user AD to sharepoint 2013

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

office-sharepoint-server-administration
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

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

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.


· 2
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.

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


0 Votes 0 ·

Hi @Gone-9731

The users added in SQL is identified with Form based Authentication (FBA), so we could not add AD users to SQL.


0 Votes 0 ·