Question

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.



Sponsored



Replies

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: https://www.concurrency.com/blog/august-2016/authenticate-to-azure-sql-database-using-azure-act

 

Best Regards,

Teige

 

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


Hello,

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.



Regards,

Alberto Morillo
SQLCoffee.com