We can set up Azure Active Directory (Azure AD) authentication for SQL Server.
To perform Azure AD authentication, SQL Server needs to be able to query Azure AD and requires an Azure AD app registration, which it can authenticate as. The app registration also needs a handful of permissions for the queries SQL Server will perform
Check below link.