question

MSTechie-7364 avatar image
0 Votes"
MSTechie-7364 asked KalyanChanumolu-MSFT answered

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

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

windows-server-powershellazure-sql-database
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @MSTechie, Could you please explain your true case in more detail way. What are you trying to achieve here. Thanks

0 Votes 0 ·

1 Answer

KalyanChanumolu-MSFT avatar image
0 Votes"
KalyanChanumolu-MSFT answered

@MSTechie-7364 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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.