PowerShell with Azure CLI to Azure SQL using Azure AD Authentication ?

Question

I know that Azure SQL supports Azure AD Password authentication and Azure AD Integrated Authentication.

If i want to communicate from my PowerShell (with Azure CLI modules installed) to Azure SQL PaaS , then can i use Azure AD Authentication ? ( Basically i dont want to use SQL authentication and use only Azure AD authentication )

If not Azure AD, can i use Service Principal (created from Azure AD tenant ) to connect from PowerShell to Azure SQL

Answer 1

@MS Techie Thank you for reaching out.
Yes you can use Azure AD authentication with Azure SQL Database from Powershell.

Please check the articles here and here for detailed instructions.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.