Create SQL user from Azure AD user

Category: sql server tools


AthiraS on Wed, 03 May 2017 10:26:27


How can I create a SQL user from Azure AD user ? 

Can Anyone provide any information regarding this. Any information is greatly appreciated.


Teige Gao on Thu, 04 May 2017 07:41:16

Hi AthiraS,


Could you please tell us which SQL Server did you mention above? Azure SQL Database or SQL Server installed on Azure VM?


If it is Azure SQL Database, you can use Azure Active Directory to authenticate it, for more information, please refer to this article:


Best Regards,



AthiraS on Thu, 04 May 2017 12:56:49

I am using SQL Server 2016 installed on Azure VM . In that case how can I authenticate it ?

Alberto Morillo on Thu, 04 May 2017 13:49:46


AAD is available for SQL Azure and SQL Azure Databases, but is not available for SQL Server IaaS (SQL Server on a VM).

Hope this helps.


Alberto Morillo