How to grant access to MS SQL to users from AD?

Question

Active Directory

How to make that to MS SQL it would be possible to adjust users and accesses to bases through AD?

Answer 1

MSSQL can do this by default - in the security section, you need to add a user by entering his login from AD, taking into account the domain\user1 domain and assigning the required rights to him.
The user on his machine launches the application / studio, selects authorization through AD and immediately connects, without even requiring a password.

Answer 2

Through snap "Users and computers"? No way. AD knows nothing about the presence or absence of certain databases on a certain server. Rights management is done from the studio - that's where you can add a domain login.