Active Directory Authentication to SQL Server

Question

I would like to Windows Authentication for our SQL Servers. In the past I would add the user window login to the Logins for SQL Server but maintenance was an ordeal. Is it possible to have SQL Server use AD or AAD to authenticate to the database. So anyone could connect and then the permissions would be set using the application code.

Answer 1

Your question is not exactly clear, but note that you can create a login for a Windows group. So if a new person joins the company and should be able to access the database, this can actually be controlled through the AD by adding that person to that Windows group.

Answer 2

Hi @Hannah Melton ,

Please check the following post for reference:

How to add Active Directory user group as login in SQL Server

Azure Active Directory User/Group And Azure SQL Database or Configure and manage Azure AD authentication with Azure SQL

---

If the 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.