Share via

How to configure AD account to access to MSSQL database ?

AZZOUZ Mustapha 0 Reputation points
2024-10-09T17:03:38.24+00:00

How to configure access to MSSQL database using AD service account ?

SQL Server Other

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    2024-10-10T02:11:04.3733333+00:00

    Hi @AZZOUZ Mustapha

    Please follow below steps to add AD account to sql server.

    1. Create AD user account in domain server as below screenshot. 10-10-1
    2. Connect to SQL server instance using a admin account, add AD account to SQL server login, grant the correct role and permissions to this account.
    • Under security folder ->right click logins folder -> choose new login option->add AD account under general tag as below screenshot (please confirm the location is Entire Directory when you choose AD account)10-10-2

    10-10-3

    • Grant the corresponding role that you want to AD account under server role tag. 10-10-4

    Grant AD account to corresponding DB that you want under user mapping tag.

     10-10-5

    If the answer is helpful, please click "Accept Answer" and kindly upvote it.

    1 person found this answer helpful.
    0 comments
  2. Olaf Helper 47,436 Reputation points
    2024-10-09T17:09:38.29+00:00

    using AD service account ?

    By adding the service account to SQL Server security and granting permission for, as for any other AD user account; what's the problem?

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.