Hey @Nitin G ,
Below are the steps:
- Add a user in AD admin in SQL server
- Then login via that AD account through SSMS and execute the below query:
CREATE USER [<<AD Group Name>>] FROM EXTERNAL PROVIDER
exec sp_addrolemember 'db_owner', '<<AD Group Name>>'
Rather than db_owner you can provide other access like data_reader or data_writer etc.