Connect Local SQL Server Database using Azure Active Directory Credentials

Question

The SQL Server (version 2016) is located in the local Virtual Machine(Windows Server 2012 R2) and I need to provide authentication for the users in the Azure Active Directory. As I am new to this I am not even sure whether it is possible or not. Can anybody guide me.

Answer 1

No, it is impossible. Please refer to this official document.

Connecting to SQL Server running on an Azure VM is not supported using an Azure Active Directory account. Use a domain Active Directory account instead.

It means if your local sql server could not use Azure Active Directory Authentication. You could use local domain Active Directory users.

If you use Azure SQL Database and SQL Data Warehouse, you could use Azure Active Directory authentication. Please refer to this link.